是这样的, 先alert tablespace test offline; drop tablespace test 然后再人工删除数据库文件;
ORA-00604 error occurred at recursive SQL level num Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables. Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support. ORA-02429 cannot drop index used for enforcement of unique/primary key Cause: An attempt was made to drop an index that is being used as the enforcement mechanism for a unique or primary key. Action: Drop the integrity constraint instead of dropping the index.
DROP USER USER_NAME CASCADE;
在删除表空间,
drop tablespace test
只是要補充一點
如果表空間不是空的﹐就要加參數 including contents
还有个方法,就是把这个表空间对应的数据文件删除了,
SVRMGRL
SVRMGRL>CONNECT INTERNAL/ORACLE
SVRMGRL>ALTER DATABASE DATAFILE '/USR/ORACLE/.../TEST.ORA' OFFLINE DROP;
SVRMGRL>DROP TABLESPACE TEST;
先alert tablespace test offline;
drop tablespace test
然后再人工删除数据库文件;
Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support. ORA-02429 cannot drop index used for enforcement of unique/primary key Cause: An attempt was made to drop an index that is being used as the enforcement mechanism for a unique or primary key.
Action: Drop the integrity constraint instead of dropping the index.