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:

ALTER SYSTEM SET “_recyclebin”= FALSE SCOPE=BOTH;

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

ALTER SESSION SET recyclebin = OFF;

ALTER 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!