Oracle DB Error ORA-22868 table with LOBs contains segments in different tablespaces

Oracle DB Error ORA-22868 table with LOBs contains segments in different tablespaces

The following is the cause of this error:

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 you can take to resolve this issue: Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution