purge recyclebin : recyclebin « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. recyclebin

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>








Related examples in the same category

1.A dropped table is preserved in the recycle bin until purged.