Pages

Sunday, August 18, 2024

See objects in RECYCLEBIN and Purge RECYCLEBIN

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