Delete the strange table name BIN in Oracle $... Method

Deleting a database table from Oracle 10 Gb does not actually Delete the table, but stores the table in recyclebin. This process is similar to that of deleting files in windows and is temporarily stored in the recycle bin.

The system automatically renames the deleted table as the name starting with BIN $.

You can run the show recyclebin command to view the details of the deleted table or query the table:

Select * from recyclebin;

Command for table revocation:

Flashback table original table name to before drop;

Command to clear the recycle bin:

Purge recyclebin;

If you want to directly delete a table without going through the recycle bin:

Drop table name purge;

Or disable the database recycle bin function:

In version 10.1, modify the hidden parameter: _ recyclebin

Alter system set "_ recyclebin" = false;

In MySQL 10.2:

Alter system set recyclebin = off;