重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-22868: table with LOBs contains segments in different tablespaces [打印本页]

作者: 郑全 时间: 2021-8-12 01:38
标题: ORA-22868: table with LOBs contains segments in different tablespaces
当我删除表空间时，提示：SQL> drop tablespace tsp_corruption INCLUDING CONTENTS;
drop tablespace tsp_corruption INCLUDING CONTENTS
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces

SQL> select owner,table_name , column_name from dba_lobs where tablespace_name='TSP_CORRUPTION’;

OWNER TABLE_NAME COLUMN_NAME

—————————— —————————— ——————————————————————————–

...

his 持续改进_201501090807 附件

。。。

SQL> drop table HIS.持续改进_201501090807 purge;

。。。

之后，再去删除表空间即可。

SQL> drop tablespace tsp_corruption INCLUDING CONTENTS;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)