Wednesday 11 April 2012

ORA-22868: table with LOBs contains segments in different tablespaces

ORA-22868: table with LOBs contains segments in different tablespaces

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.

No comments:

Post a Comment