The new 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):
purge dba_recyclebin; ALTER SYSTEM SET recyclebin = OFF;
If you are using Oracle RAC, you must disable the recycle
bin for each instance in the cluster.
To view the contents of the recycle bin:
select * from dba_recyclebin;
To view the current recycle bin configuration:
select inst_id, value from gv$parameter
