对于ORA-02429这个错误,MOS文档的描述也很清楚:
Drop Tablespace Failed with ORA-02429: cannot drop index used for enforcement of unique/primary key (文档 ID 1918060.1)
删除表空间失败,伴随下面的错误:
SQL> DROP TABLESPACE REP_DATA INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE REP_DATA INCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-02429: cannot drop index used for enforcement of unique/primary key 解决方法:Find the constraint name for the unique/primary key, disable the constraint and drop the tablespace again.
找到那些惟一/主键约束名,禁用这些约束然后再次删除表空间。
建议的操作方法如下:
1、下载一个lsof软件装上,google上可以搜到
2、找到正在用被删文件的进程
lsof | grep deleted
3、kill掉相应的进程空间就释放了
一般这种情况,并不建议重启数据库或主机。