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

RMAN-08016: channel string: starting datafile backupset restore

1 Answers  


ORA-16194: Modifying DB_UNIQUE_NAME requires SID='*' qualifier

1 Answers  


ORA-30201: Unable to load NLS data object

1 Answers  


ORA-35076: (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.

1 Answers  


PCC-00018: Expected "string", but found "string" at line number in file string

1 Answers  






LPX-00248: invalid entity declaration

1 Answers  


PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression

1 Answers  


TNS-00549: value specified for the SSL version is not valid

1 Answers  


NNL-00012: invalid "string" value "string"

1 Answers  


ORA-29512: incorrectly formed name resolver specification

1 Answers  


DRG-51803: failed to open file: %(1)

1 Answers  


PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB

1 Answers  


Categories