How to purge objects that have been dropped
How to purge objects that have been dropped
Log on to sqlplus as the user of the drop object
Then show recyclebin;
F: \ Oracle \ product \ 10.2.0 \ db_1 \ BIN> sqlplus/as sysdba
SQL * Plus: Release 10.2.0.4.0-Production on Thu Feb 19 09:04:17 2015
Copyright (c) 1982,200 7, Oracle. All Rights Reserved.
Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
12:41:11 sys @ FS> conn system/aaaaaa
Connected.
12:41:17 system @ FS> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
-----------------------------------------------------------------------------
Xxx bin $ T7ZJRNkmQcGysyaMOwZS9Q ==$ 0 TABLE 2015-02-19: 12: 38: 44
12:41:22 system @ FS> purge table "BIN $ T7ZJRNkmQcGysyaMOwZS9Q = $0 ";
Table purged.
Elapsed: 00:00:00. 51
12:45:38 system @ FS> show recyclebin;
12:45:40 system @ FS>
This is only one object in the purge recycle bin. In fact, there are several other types of purge granularity:
Purge index idx_test_1;
Purge tablespace users;
Purge tablespace users user scott;
Purge recyclebin; ---> objects under the user in the purge recycle bin are not the entire purge Recycle Bin (objects under all users in the purge recycle bin are not)
PURGE DBA_RECYCLEBIN; ---> purge entire recycle bin (objects under all users in the purge recycle bin)
In fact, DBA_RECYCLEBIN is also a select view, where TS_NAME is the name of the tablespace where the object is located. The TS_NAME column serves as a diagnosis when drop datafile reports ORA-03262: the file is non-empty.