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!