文档库 最新最全的文档下载
当前位置:文档库 › 如何删除名称以BIN$开头的表

如何删除名称以BIN$开头的表

如何删除名称以BIN$开头的表

SQL> select * from user_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$nJ5JuP9cQmqPaArFei384g==$0

TEST DROP TABLE ROME 2007-03-08:10:49:36

2007-03-20:09:38:13 11311453 YES YES 60025 60025 60025 8 BIN$/d2RP/L5SCmBAtczQZvKTA==$0

PK_TEST DROP INDEX ROME 2007-03-09:16:57:22

2007-03-20:09:38:13 11311449 NO YES 60025 60025 60151 8 BIN$QoxoonHNRRSZ/sdsnNK91A==$0

TEST_MY DROP TABLE ROME 2007-03-07:10:42:55

2007-03-19:15:28:27 11243640 YES YES 59940 59940 59940 8 BIN$uWpdwiSPRx6wvUJwAEyQ4A==$0

T2 DROP TABLE ROME 2007-03-15:09:53:33

2007-03-16:15:32:20 10997403 YES YES 60684 60684 60684 8 BIN$M4D+ImL7SlSQVqvweZwspg==$0

SYS_C0010746 DROP INDEX ROME 2007-03-15:09:53:33

2007-03-16:15:32:20 10997401 NO YES 60684 60684 60685 8 BIN$KfazB1b/RI6m1HbT72Jm0w==$0

T1 DROP TABLE ROME 2007-03-09:10:22:31

2007-03-16:15:32:18 10997385 YES YES 60115 60115 60115 8 BIN$1EIvA8GiTvGgeT07o+Buog==$0

SYS_C0010460 DROP INDEX ROME 2007-03-09:10:22:31

2007-03-16:15:32:18 10997381 NO YES 60115 60115 60116 8

相关文档