See Recyclebin
COL owner FOR A30
COL original_name FOR A30
COL object_name FOR A30
SELECT owner, original_name, object_name, type, droptime
FROM DBA_RECYCLEBIN;
Purge a specific table
PURGE TABLE RB$$33750$TABLE$0;
Purge schema Recyclebin
PURGE RECYCLEBIN;
Purge all Recyclebin
PURGE DBA_RECYCLEBIN;
No comments:
Post a Comment