Disabling Oracle Recycle Bin

If you do not intend to use the Recycle Bin at the replicate Oracle database, you can manually disable it.

Prerequisites

Disabling the Recycle Bin requires the sysdba privilege.

Task

Enter this command, and then restart the replicate Oracle database:

ALTER SYSTEM SET RECYCLEBIN=OFF SCOPE=SPFILE;

Or, if you are using a version of Oracle that does not have the RECYCLEBIN parameter, enter:

ALTER SYSTEM SET "_recyclebin"=FALSE SCOPE=BOTH;

Note: If you are using Oracle RAC, disable the recycle bin for each instance in the cluster.