-- 或者直接在删除表的时候加个“purge”关键字:意思是直接删除表,不经过回收站。-- 例如: drop table table_name purge;
-- 下面是操作步骤示例:SCOTT@tdwora > show recyclebin; SCOTT@tdwora > select table_name from user_tables;TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE T SPERRORLOG EMP_CP已选择7行。SCOTT@tdwora > drop table t;表已删除。SCOTT@tdwora > show recyclebin; ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ------------------------------ ------------ ------------------- T BIN$RfvUEcO5QHmXQC9fobwjGw==$0 TABLE 2012-06-06:11:10:36 SCOTT@tdwora > drop table "BIN$RfvUEcO5QHmXQC9fobwjGw==$0"; drop table "BIN$RfvUEcO5QHmXQC9fobwjGw==$0" * 第 1 行出现错误: ORA-38301: 无法对回收站中的对象执行 DDL/DML SCOTT@tdwora > drop table t purge; drop table t purge * 第 1 行出现错误: ORA-00942: 表或视图不存在 SCOTT@tdwora > purge recyclebin;回收站已清空。SCOTT@tdwora > show recyclebin; SCOTT@tdwora >
我的意思是我直接 drop table 了,但没删除分区,现在想彻底删除分区,该这么办!!!
PURGE TABLE table_name;
删除,
-- 执行下面的语句清空回收站:purge recyclebin;
drop table table_name purge;
SCOTT@tdwora > select table_name from user_tables;TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
T
SPERRORLOG
EMP_CP已选择7行。SCOTT@tdwora > drop table t;表已删除。SCOTT@tdwora > show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$RfvUEcO5QHmXQC9fobwjGw==$0 TABLE 2012-06-06:11:10:36
SCOTT@tdwora > drop table "BIN$RfvUEcO5QHmXQC9fobwjGw==$0";
drop table "BIN$RfvUEcO5QHmXQC9fobwjGw==$0"
*
第 1 行出现错误:
ORA-38301: 无法对回收站中的对象执行 DDL/DML
SCOTT@tdwora > drop table t purge;
drop table t purge
*
第 1 行出现错误:
ORA-00942: 表或视图不存在
SCOTT@tdwora > purge recyclebin;回收站已清空。SCOTT@tdwora > show recyclebin;
SCOTT@tdwora >