휴지통 비우기.
S SYS> purge recyclebin;
Recyclebin purged.
S SYS> select * from dba_recyclebin;
OWNER OBJECT_NAME ORIGINAL_NAME OPERATION
------------------------------ ------------------------------ -------------------------------- ---------
TYPE TS_NAME CREATETIME DROPTIME DROPSCN
------------------------- ------------------------------ ------------------- ------------------- ----------
PARTITION_NAME CAN CAN RELATED BASE_OBJECT PURGE_OBJECT SPACE
-------------------------------- --- --- ---------- ----------- ------------ ----------
SCOTT BIN$bK1FgGMZ3CPgQAB/AQBkPg==$0 TM DROP
TABLE USERS 2009-06-16:15:33:49 2009-06-19:13:51:03 11493657
YES YES 53354 53354 53354 8
SCOTT BIN$bP4Ag2vvi//gQAB/AQBZQA==$0 EMP18 DROP
TABLE USERS 2009-06-23:14:10:02 2009-06-23:14:14:57 11665382
YES YES 54174 54174 54174 8
SCOTT BIN$bP4Ag2vwi//gQAB/AQBZQA==$0 EMP19 DROP
TABLE USERS 2009-06-23:14:09:48 2009-06-23:14:15:01 11665392
YES YES 54173 54173 54173 8
S SYS> purge dba_recyclebin;
DBA Recyclebin purged.
S SYS> select * from dba_recyclebin;
no rows selected
지울때 뒤에 purge 붙이면 휴지통에 안 가고 없어짐.
ex) drop table emp18 purge;
--휴지통 속성 보기
S SYS> select original_name, object_name, type, ts_name,droptime,related,space from dba_recyclebin where can_undrop = 'YES';
ORIGINAL_NAME OBJECT_NAME TYPE
-------------------------------- ------------------------------ -------------------------
TS_NAME DROPTIME RELATED SPACE
------------------------------ ------------------- ---------- ----------
D2 BIN$bP4Ag2vxi//gQAB/AQBZQA==$0 TABLE
USERS 2009-06-23:14:19:25 54175 8
--휴지통 내용 보기
S SYS> select * from scott."BIN$bP4Ag2vxi//gQAB/AQBZQA==$0";
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
'DataBase > Oracle' 카테고리의 다른 글
CUBE 사용예 (0) | 2010.05.18 |
---|---|
sqlplus 셋팅 영구저장 방법 (0) | 2010.05.18 |
리스너 권한 문제로 실행안되는 문제. (0) | 2010.05.18 |
Configuring Recovery Manager (0) | 2010.05.18 |
Moving Data (0) | 2010.05.18 |