ORA-22868: table with LOBs contains segments in different
tablespaces



ORA-22868: table with LOBs contains segments in different tablespaces..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains the segment(s) for the LOB columns of a table but
does not contain the table segment.

Action: Find table(s) with LOB columns which have non-table
segments in this tablespace. Drop these tables and reissue
drop tablespace.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07492: scgrcl: cannot close lock.

1 Answers  


DRG-12303: cannot add more than 99 indexes to an index set

1 Answers  


ORA-12416: policy string not found

1 Answers  


ORA-24354: number fetched too large to fit in COBOL display type buffer.

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  






ORA-12232: TNS:No path available to destination

1 Answers  


UDI-00016: 'string' parameter requires a value.

1 Answers  


ORA-07224: sfnfy: failed to obtain file size limit; errno = string.

1 Answers  


DRG-11503: insert statement overflows maximum statement size

1 Answers  


LSX-00122: value is not valid restriction of parent's whiteSpace

1 Answers  


IMP-00013: only a DBA can import a file exported by another DBA

1 Answers  


RMAN-06410: cannot use command when channels are allocated

1 Answers  


Categories