recovery

Turn Off Recycle Bin Option Oracle

Karan Balkar
Hello everyone! Starting from Oracle version 10g, a new feature known as RecycleBin was introduced to recover dropped tables. Dropped tables go "into" the recyclebin, and can be restored (undropped) from the recyclebin. By default the RECYCLEBIN option is ON. Hence you can recover the tables dropped, by using the FLASHBACK table command as follows! Pre-requisites: Oracle database 10g Express Edition with *SQLPlus Open *SQLPlus and run the following commands! DROP TABLE YOURTABLENAME; FLASHBACK TABLE YOURTABLENAME TO BEFORE DROP; Check parameter RECYCLEBIN using the below command