[原創] ORA-22868 快速解決

1.問題現象

SQL> drop tablespace TS_LOB including contents and datafiles ;
drop tablespace TS_LOB including contents and datafiles
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces

2.解決過程

SQL> select owner,table_name,tablespace_name from dba_lobs where tablespace_name='TS_LOB';

OWNER           TABLE_NAME                     TABLESPACE_NAME
--------------- ------------------------------ --------------------
YXYUP           BIN$VmHA+aMlWWjgQKjABDwcBg==$0 TS_LOB

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

SQL> select owner,table_name,tablespace_name from dba_lobs where tablespace_name='TS_LOB';

no rows selected

SQL> drop tablespace TS_LOB including contents and datafiles ;

Tablespace dropped.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7364032/viewspace-442424/，如需轉載，請註明出處，否則將追究法律責任。