Disabling the Oracle Recycle Bin in Oracle 10g

Turn Off Disable Oracle Recycle Bin


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 it to FALSE.

Command to disable that would be:

1ALTER SYSTEM SET “\_recyclebin= FALSE SCOPE=BOTH;

ORACLE 10g RELEASE 2 the following syntax to turn the recycle bin off is:

1ALTER SESSION SET recyclebin = OFF;
2
3ALTER SYSTEM SET recyclebin = OFF;

The dropped objects that where in the recyclebin will remain there even when the recyclebin parameter is set to off.

Keep your oracle database clean and green! See the Oracle SQL paga for other Scripts

Posts in this Series