oracle删除表空间删除不掉

来源：互联网发布：淘宝天天特价是真的吗编辑：程序博客网时间：2024/04/27 17:45
2014年4月8号，一网友说他要删除一数据库中的表空间，删除不掉。下面是远程操作的具体信息。先说下环境，os 为linux，oracle 11gr2 ,表空间下的数据文件也一并删除。
SQL> show userUser is "SYS" SQL> SQL> drop user SHAREPLATFORMDB cascade; drop user SHAREPLATFORMDB cascade ORA-01940: cannot drop a user that is currently connected SQL> drop tablespace SHAREPLATFORMDB including contents and datafiles ; drop tablespace SHAREPLATFORMDB including contents and datafiles ORA-00604: error occurred at recursive SQL level 1ORA-38301: can not perform DDL/DML over objects in Recycle Bin SQL> SQL> show parameter recyclebin NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------recyclebin                           string      on SQL> alter session set recyclebin=off  2  ; Session altered SQL> show recyclebinSQL> show parameter recyclebin NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------recyclebin                           string      on SQL> drop tablespace SHAREPLATFORMDB including contents and datafiles ; drop tablespace SHAREPLATFORMDB including contents and datafiles ORA-00604: error occurred at recursive SQL level 1ORA-02429: cannot drop index used for enforcement of unique/primary key SQL> select * from recyclebin; OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE                      TS_NAME                        CREATETIME          DROPTIME               DROPSCN PARTITION_NAME                   CAN_UNDROP CAN_PURGE    RELATED BASE_OBJECT PURGE_OBJECT      SPACE------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------BIN$y5Q74oRzRZiuOOKKMyfBUA==$0 RESEVALUATE                      DROP      TABLE                     USERS                          2014-04-01:10:36:41 2014-04-01:10:42:44   14221202                                  YES        YES            85874       85874        85874         24 SQL> drop table "BIN$y5Q74oRzRZiuOOKKMyfBUA==$0"; Table dropped SQL> select * from recyclebin; OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE                      TS_NAME                        CREATETIME          DROPTIME               DROPSCN PARTITION_NAME                   CAN_UNDROP CAN_PURGE    RELATED BASE_OBJECT PURGE_OBJECT      SPACE------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ---------- SQL> purge tablespace SHAREPLATFORMDB; Done SQL> purge tablespace SHAREPLATFORMDB user SHAREPLATFORMDB; Done SQL> select name from v$tablespace; NAME------------------------------SYSTEMSYSAUXUNDOTBS1USERSTEMPSHAREPLATFORMDBSHAREGISDATADBSDENSHAREAPPDBNSHAREPLATFORMDB 10 rows selected SQL> drop tablespace SHAREPLATFORMDB; Tablespace dropped SQL> select name from v$tablespace; NAME------------------------------SYSTEMSYSAUXUNDOTBS1USERSTEMPSHAREGISDATADBSDENSHAREAPPDBNSHAREPLATFORMDB 9 rows selected SQL> show parameter recyclebin NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------recyclebin                           string      on SQL>
0 0