Disabling Oracle Recycle Bin

If you do not intend to use the Recycle Bin at the replicate Oracle database, you can disable it manually. To disable the Recycle Bin, which requires the sysdba privilege, enter the following 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 the following:

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

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