Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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>