A dropped table is preserved in the recycle bin until purged. : recyclebin « SQL Plus « Oracle PL / SQL






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

  

SQL>
SQL>
SQL> create table myTable (col1 number primary key);

Table created.

SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL> select object_name, original_name, type from recyclebin;

no rows selected

SQL>
SQL> purge recyclebin;

Recyclebin purged.

SQL>
SQL> select object_name, original_name, type from recyclebin;

no rows selected

SQL>
SQL>
SQL>

   
    
  








Related examples in the same category

1.purge recyclebin