To remove your own dropped object from the recycle bin do:-
PURGE RECYCLEBIN;
Alternatively issue
alter session set recyclebin=off ;
before dropping the object.
If you are important enough (i.e. have the privs)
Purge dba_recyclebin;
will drop all recyclebin objects.http://www.oracle.com/technology/pub/articles/10gdba/week5_10gdba.html
Thursday, 7 August 2008
Subscribe to:
Posts (Atom)