When you delete a database table from Oracle10g, the table is not deleted, but stored in recyclebin. This process is similar
When deleting a database table from Oracle 10 Gb, the table is not deleted, but stored in recyclebin. This process is similar
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 a file 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;