SQL> select * from tab;TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
SALGRADE TABLE
BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
EMPLOYEE_HOPE TABLE
STUDENT TABLE
STU TABLE
CUSTOMER TABLE
SALES TABLE
SALE_ITEM TABLE
STOCK TABLE
PRODUCT TABLE
PUR_ITEM TABLE
SUPPLY TABLE
WARES TABLE
MY_BOOK_TEXT TABLE
SALE TABLE
GOODS TABLE
SHUJU TABLE已选择19行。
SQL> drop table wares;表已删除。
SQL> select * from tab;TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
SALGRADE TABLE
BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$qSSIXRUGQP6V7e/tT4HfnQ==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
EMPLOYEE_HOPE TABLE
BIN$HtSHC9cOQY6cyzY+LGGPCw==$0 TABLE
BIN$67gF8/qoQd+yqGbw0iygNA==$0 TABLE
STUDENT TABLE
CUSTOMER TABLE
SALES TABLE
SALE_ITEM TABLE
STOCK TABLE
PRODUCT TABLE
PUR_ITEM TABLE
SUPPLY TABLE
MY_BOOK_TEXT TABLE
SALE TABLE
GOODS TABLE已选择19行。BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$qSSIXRUGQP6V7e/tT4HfnQ==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
这是什么意思啊??
------------------------------ ------- ----------
DEPT TABLE
SALGRADE TABLE
BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
EMPLOYEE_HOPE TABLE
STUDENT TABLE
STU TABLE
CUSTOMER TABLE
SALES TABLE
SALE_ITEM TABLE
STOCK TABLE
PRODUCT TABLE
PUR_ITEM TABLE
SUPPLY TABLE
WARES TABLE
MY_BOOK_TEXT TABLE
SALE TABLE
GOODS TABLE
SHUJU TABLE已选择19行。
SQL> drop table wares;表已删除。
SQL> select * from tab;TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
SALGRADE TABLE
BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$qSSIXRUGQP6V7e/tT4HfnQ==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
EMPLOYEE_HOPE TABLE
BIN$HtSHC9cOQY6cyzY+LGGPCw==$0 TABLE
BIN$67gF8/qoQd+yqGbw0iygNA==$0 TABLE
STUDENT TABLE
CUSTOMER TABLE
SALES TABLE
SALE_ITEM TABLE
STOCK TABLE
PRODUCT TABLE
PUR_ITEM TABLE
SUPPLY TABLE
MY_BOOK_TEXT TABLE
SALE TABLE
GOODS TABLE已选择19行。BIN$x3UkPw6STwyejMg4SG72jg==$0 TABLE
BIN$qSSIXRUGQP6V7e/tT4HfnQ==$0 TABLE
BIN$yjUtLA1ISfq2tzLr+vJ/Cg==$0 TABLE
这是什么意思啊??
如果你需要彻底删除,可以使用.
Delete table xxx purge;
就不放入回收站,直接删除了。