oralce drop操作不是真正的shift+delete

  

drop table table_name;
drop table table_name cascade constraints;
drop table table_name purge;

The drop table command moves a table into the recycle bin unless purge was also specified.

purge

Normally, a table is moved into the recycle bin (as of Oracle 10g), if it is dropped. However, if the purge modifier is specified as well, the table is unrecoverably (entirely) dropped from the database.

cascade constraints

Deletes all foreign keys that reference the table to be dropped, then drops the table.

Thanks

Thanks to Steve Parker and Thorir Olafsson who notified me of a typo on this page. 

参考

http://space.itpub.net/35489/viewspace-376244