SQL Plus Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. SQL Plus
  4. 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>