The Oracle flashback feature available in Oracle 10g is not supported in Replication Agent for Oracle. Oracle requires that you disable the recycle bin. To disable the recycle bin (which requires sysdba privileges), enter the following command, and then restart Oracle:
purge dba_recyclebin; alter system set recyclebin=OFF scope=spfile;
If you are using Oracle RAC, disable the recycle bin
for each instance in the cluster.
To view the contents of the recycle bin, enter the following:
select * from dba_recyclebin;
To view the current recycle bin configuration, enter the following:
select inst_id, value from gv$parameter
