If the replicate Oracle database does not have the Recycle Bin enabled, any command that accesses Recycle Bin objects at the replicate database will fail. You should therefore disable the replication of Flashback DDL commands in one of the following ways:
Use the pdb_setrepddl command to prevent the replication of Flashback DDL commands. See the Replication Agent Reference Manual.
Add a “warning” error action for Flashback DDL execution failure to Replication Server so that replication can continue with the replicate Recycle Bin disabled. Run the following Replication Server script against the RSSD:
$SYBASE/RAX-15_5/scripts/oracle/ hds_oracle_setup_flashback_errors.sql
After you run this script, you must restart Replication Server.
This script uses the rs_oracle_error_class default
error class as a template. If you are using custom error class and
want Replication Server to continue replicating without interruption,
you must instruct Replication Server to display warning messages
38305 and 38307 in its error log:
assign action warn for your_error_class to 38305, 38307
where your_error_class is the name of your custom error class.
To remove the “warning” error action for Flashback DDL execution failure to Replication Server, run the following Replication Server script against the RSSD:
$SYBASE/RAX-15_5/scripts/oracle/ hds_oracle_remove_flashback_errors.sql
