Oracle deletes a table starting with Bin

Oracle deletes tables starting with Bin to delete tables starting with Bin, that is, tables that are already DROP but exist in the recycle Bin: --> www.2cto.com query all such tables SQL> SELECT * from recyclebin where type = 'table'; Delete All Tables SQL> purge recyclebin in the recycle bin; Delete the specified table SQL> PURGE TABLE table_name; flash back TO the deleted table SQL> flashback table table_name to before drop; --> Of course, you can DROP the TABLE without generating a Bin-type table SQL> DROP TABLE table_name PURGE;