Daily Archives: Thursday, January 4, 2007

Turn Off Disable Oracle Recycle Bin

Posted by & filed under Oracle RAC.

In a comment today about the Empty Oracle Recycle Bin , A person wanted to know how one turns off or disables the Oracle Recycle Bin?In ORACLE 10G Release 1 there is a knob to turn to disable the behavior of recycling bin. The “_recyclebin” which defaults to TRUE. We can disable it by setting… Read more »

Empty Oracle Recycle Bin

Posted by & filed under Oracle RAC.

 A new feature in Oracle 10g Release 2 was the Reycycle Bin. The recycle bin in the Oracle database is where all dropped objects reside. Underneath the covers the object are taking up the same space when they were created.     "DROP TABLE mytable", it doesn't really drop it. It instead renames it to e.g.:… Read more »