| Semantics |
| Related Data Dictionary Objects |
| recyclebin$
|
dba_recyclebin |
recyclebin |
user_recyclebin |
|
| Initialization Parameter |
The recyclebin init parameter
controls this feature: See links at page bottom
|
| |
Recycle Bin Object |
DESC recyclebin
SELECT * FROM recyclebin;
SHOW recyclebin |
Remove A Recycle Bin Object By Name |
PURGE TABLE "<recycle_bin_name>"; |
conn / as sysdba
GRANT unlimited tablespace TO uwclass;
conn uwclass/uwclass
SELECT tablespace_name
FROM user_tablespaces;
CREATE TABLE test1
TABLESPACE uwdata AS
SELECT * FROM user_objects;
CREATE TABLE test2
TABLESPACE example AS
SELECT * FROM user_objects;
CREATE TABLE test3
TABLESPACE users AS
SELECT * FROM user_objects;
SELECT object_name, original_name
FROM user_recyclebin;
DROP TABLE test1;
DROP TABLE test2;
DROP TABLE test3;
SELECT object_name, original_name, ts_name
FROM user_recyclebin;
PURGE TABLE "BIN$V3zj9aOWRImOT89aKyyVSg==$0";
SELECT object_name, original_name, ts_name
FROM user_recyclebin;
PURGE TABLE TEST1;
SELECT object_name, original_name, ts_name
FROM user_recyclebin;
conn / as sysdba
REVOKE unlimited tablespace FROM uwclass; |
Remove Recycle Bin Objects By Tablespace |
PURGE TABLESPACE <tablespace_name>; |
CREATE TABLE test1
TABLESPACE uwdata AS
SELECT * FROM user_objects;
CREATE TABLE test3
TABLESPACE example AS
SELECT * FROM user_objects;
DROP TABLE test1;
DROP TABLE test3;
SELECT object_name, original_name, ts_name
FROM user_recyclebin;
PURGE TABLESPACE
example;
SELECT object_name, original_name, ts_name
FROM user_recyclebin; |
| Remove Recycle Bin Objects By Tablespace And User |
PURGE TABLESPACE <tablespace_name>
USER <schema_name>; |
|
PURGE TABLESPACE uwdata USER uw; |
| Empty The Recycle Bin |
PURGE recyclebin; |
| Empty Everything In All Recycle Bins |
PURGE
dba_recyclebin; |