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

LSX-00175: a complex base within "simpleContent" must have simple content

1 Answers  


ORA-25965: fact table must be included in the from clause

1 Answers  


TNS-12597: TNS:connect descriptor already in use

1 Answers  


DRG-50939: parser not set

1 Answers  


ORA-13220: failed to compare tile with the geometry

1 Answers  






TNS-12228: TNS:protocol adapter not loadable

1 Answers  


PLS-00206: %%TYPE must be applied to a variable, column, field or attribute, not to "string"

1 Answers  


TNS-00081: * trace_on - ask process name to turn tracing on

1 Answers  


RMAN-20217: datafile not part of the database

1 Answers  


ORA-16107: all log data from primary has been processed

1 Answers  


ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

1 Answers  


ORA-37122: AW Session cache disabled

1 Answers  


Categories