The benefit of the oracle10g Recycle Bin is that when a table is mistakenly deleted, there is a mechanism for recovery, but if you do not need to use this feature, you can use the command to close
1. Turn off or turn on the Recycle Bin function
ALTER SESSION SET Recyclebin=on;
ALTER SYSTEM SET Recyclebin=off;
2. Restore the table from the Recycle Bin
Recovery table, with the function of the flashback table:
FLASHBACK TABLE Zftang to before DROP;
3. View the objects in the Recycle Bin
SELECT original_name, object_name, TYPE, Droptime from User_recyclebin;
Bin$t26oqcqutri6zrln1wpsva==$0
Sql> Drop Tabletestdelete; The table has been deleted. SQL> --Oracle's Recycle binSql> --View Recycle binSql>Show recyclebinoriginal name RecycleBin name OBJECT TYPEDROP Time---------------- ------------------------------ ------------ ------------------- Testdelete Bin$oy28blkesle/Ljnupkzrmq==$0 TABLE --Ten- at: the: the: theSQL> --emptying the Recycle binSql>Purge RecycleBin2The Recycle Bin has been emptied. SQL> --Delete a table completelySql> Drop Tabletest1 purge; The table has been deleted. SQL>Show RecycleBin
Oracle Recycle Bin