How to purge objects that have been dropped, purgeddrop objects
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 sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 19 09:04:17 2015Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options12:41:11 sys@FS> conn system/aaaaaaConnected.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:4412:41:22 system@FS> purge table "BIN$T7ZJRNkmQcGysyaMOwZS9Q==$0";Table purged.Elapsed: 00:00:00.5112: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 user scott; purge recyclebin; ---> objects of the USER in the purge recycle bin, it is not the entire purge Recycle Bin (not the objects of all users in the purge recycle bin) PURGE DBA_RECYCLEBIN; ---> purge entire recycle bin (Objects of 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.