ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [原创] ORA-22868 快速解决

[原创] ORA-22868 快速解决

原创 Linux操作系统 作者:yxyup 时间:2008-09-08 20:45:30 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-06

  • 博文量
    163
  • 访问量
    1339390