怎么回收drop掉一个表的空间(二)
7788 23-5月 -87 3320 20 WOMEN
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO SEX
---------- -------------------- ------------------ ---------- -------------- ---------- ---------- ---------- --------------------
7000 MILLER hello 2000 23-1月 -82 3220 10 WOMEN
2000 rhys DBA 2000 01-5月 -13 3001 200 30 MEN
1000 xiaohai 20000 MEN
2003 xiao 2002 10 MEN
1113 BLAKE 2000 50 MEN
已选择16行。
RHYS@orcl#
####################删除用户下的某个表释放空间######
RHYS@orcl#show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$37gMKgN4rWzgQKjABIlC2A==$0 TABLE 2013-06-22:12:59:42
T1 BIN$37gMKgN5rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:00:12
RHYS@orcl#purge table t;
表已清除。
RHYS@orcl#show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T1 BIN$37gMKgN5rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:00:12
RHYS@orcl#
##################删除用户下的所有表释放空间##########
RHYS@orcl#show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$37gMKgN6rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:03:38
T1 BIN$37gMKgN5rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:00:12
RHYS@orcl#purge tablespace test user rhys;
表空间已清除。
RHYS@orcl#show recyclebin
RHYS@orcl#
#################在drop表的时候指定purge彻底删除表并回收空间#######
RHYS@orcl#drop table rhys_t purge;
表已删除。
RHYS@orcl#show recyclebin
RHYS@orcl#
#################删除表空间中所有用户的表释放空间########
RHYS@orcl#drop table rhys_t;
表已删除。
RHYS@orcl#drop table rhys_t1;
表已删除。
RHYS@orcl#show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
RHYS_T BIN$37gMKgN8rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:07:46
RHYS_T1 BIN$37gMKgN9rWzgQKjABIlC2A==$0 TABLE 2013-06-22:13:07:51
RHYS@orcl#
LILY@orcl#show recycle
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
LILY_T BIN$37gxey9KrYjgQKjABIlDLA==$0 TABLE 2013-06-22:13:10:09
LILY_T1 BIN$37gxey9LrYjgQKjABIlDLA==$0 TABLE 2013-06-22:13:10:13
LILY@orcl#
LILY@orcl#conn sys/root as sysdba;
已连接。
SYS@orcl#show recycle
SYS@orcl#purge tablespace test;
表空间已清除。
SYS@orcl#conn lily/root
已连接。
LILY@orcl#show recycle
LILY@orcl#conn rhys/root
已连接。
RHYS@orcl#show recycle
RHYS@orcl#
###################删除当前用户下的recyclebin######
RHYS@orcl#conn lily/root
已连接。
LILY@orcl#create table lily_t as select * from sco