Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Purge recyclebin

SQL> SQL> purge recyclebin; Recyclebin purged. SQL> drop table vacation; SQL> SQL> select object_name, original_name, droptime   2  from   recyclebin; no rows selected SQL> SQL> flashback table vacation to before drop; SQL> SQL>