sqlplus / as sysdba purge dba_recyclebin; --> purges all recyclebin objects, globally purge tablespace user_data user scott; --> purge only scott's Objects from the user_data tablespace purge tablespace user_data; --> purge all recyclebin Objects from the user_data tablespace conn scott/tiger purge recyclebin; --> purges scott's recycle bin only
The next statement purges the specified object from the recycle bin. The first example refers directly to the system-generated name of the object, the second is refering to the original name of the object.
purge table "BIN$W/n28BqBgRbgU64JAQoz3A==$0"; purge table emp;
No comments:
Post a Comment