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

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

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