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-23480: Column string is not a top-level column of "string"."string".

1 Answers  


NNL-00980: Forwarding failures: number

1 Answers  


ORA-39038: Object path "string" is not supported for string jobs.

1 Answers  


ORA-13797: invalid SQL Id specified, string

1 Answers  


ORA-14173: illegal subpartition-extended table name syntax

1 Answers  


SQL*Loader-00555: unrecognized processing option

1 Answers  


ORA-30458: 'string.string' cannot be refreshed because the refresh mask is string

1 Answers  


PROC-00103: Messaging error

1 Answers  


ORA-07448: ssarena: maximum number of shared arenas exceeded.

1 Answers  


RMAN-06514: archived logs required to recover from this copy will not be kept

1 Answers  


NZE-29156: conditional RNG self-test failure

1 Answers  


PCC-00040: Unable to open listing file "string"

1 Answers  


Categories