Thursday, June 20, 2013
PL/SQL Purge Recycle Bin
Recently came across several objects that needed to be purged from our Oracle DW. It seems after a drop table the object still remains in the RecycleBin.
Example to query for the objects:
select 'purge table "' || object_name || '" ;' , original_name, type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin
Example of purge:
purge table "BIN$3EgaHwhNbdPgQy8CKArrew==$0" ;
Using Oracle's recycle bin
0 comments:
Post a Comment