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-09753: spwat: invalid process number.

1 Answers  


ORA-02425: create table failed

1 Answers  


LSX-00221: "~1S" is too short (minimum length is ~2d)

1 Answers  


PLS-00670: sort columns must be simple column names

1 Answers  


ORA-02485: Invalid _trace_options parameter specification (string)

1 Answers  


RMAN-08022: channel string: restoring archive log

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


RMAN-06153: validation failed for datafile copy

1 Answers  


ORA-04092: cannot string in a trigger

1 Answers  


LPX-00221: the character "<" cannot occur in attribute values

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


ORA-26040: Data block was loaded using the NOLOGGING option

1 Answers  


Categories