ORA-01692: unable to extend lob segment PROD7.SYS_LOB0000151343C00022$$
I was trying to execute the following procedure :
SQL> EXECUTE DBMS_REDEFINITION.START_REDEF_TABLE('PROD7', 'OLD_DATA', 'OLD_DATA_RD');
& got ORA-01692: unable to extend lob segment PROD7.SYS_LOB0000151343C00022$$
It means, I need to add more space on that Tablespace which contains this object PROD7.SYS_LOB0000151343C00022$$.
select owner,segment_name,segment_type,tablespace_name
from dba_segments
where
--lower(tablespace_name) like lower('%DATA02%') and
lower(segment_name) like lower('%SYS_LOB0000151343C00022%')
order by owner, segment_name;
By this query I can get the Tablespace name.
Then I add one more datafile on this Tablespace.
