Oracle's new flashback feature available in Oracle version 10g is not supported in Replication Agent for Oracle. Because flashback is not supported, it requires that you disable the recycle bin:
To disable the recycle bin which was added in Oracle 10.2 (which requires sysdba privileges):
purge dba_recyclebin; ALTER SYSTEM SET recyclebin = OFF;
To disable the recycle bin in Oracle 10.1, you must set the Oracle hidden property:
ALTER SYSTEM SET “_recyclebin”=FALSE SCOPE = BOTH;
In Oracle 10.2, to view the contents of the recycle bin:
select * from dba_recyclebin;
In Oracle 10.2, to view the current recycle bin configuration:
select value from v$parameter where name = “recyclebin”;