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

EXP-00024: Export views not installed, please notify your DBA

1 Answers  


DRG-11305: create/alter index string is in progress in another session

1 Answers  


ORA-14185: incorrect physical attribute specified for this index partition

1 Answers  


ORA-02182: savepoint name expected

1 Answers  


ORA-31526: could not find source table string.string for CDC change table string.string

1 Answers  






DRG-12604: execution of user datastore procedure has failed

1 Answers  


DRG-51313: timeout while waiting for DML or optimize lock

1 Answers  


ORA-39109: Unprivileged users may not operate upon other users' schemas

1 Answers  


ORA-30938: No prefix defined for namespace 'string' (particle string)

1 Answers  


ORA-16507: unrecognized request identifier

1 Answers  


DRG-11846: Response Is Stale

1 Answers  


ORA-22933: cannot change object with type or table dependents

1 Answers  


Categories