Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-22868 – table with LOBs contains segments in different tablespaces

Oracle Database Error Code ORA-22868 Description :

table with LOBs contains segments in different tablespaces

Error 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.

How to Solve :

Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.