Disabling Flashback Replication with Recycle Bin Disabled

Disable the replication of Oracle Flashback DDL commands when the Recycle Bin is disabled.

If the replicate Oracle database does not have the Recycle Bin enabled, any command that accesses Recycle Bin objects at the replicate database fails. You should therefore disable the replication of Flashback DDL commands.

Disable the replication of Flashback DDL commands in one of these 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 this 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.
Note: This script uses the rs_oracle_error_class default error class as a template. If you are using a 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 this Replication Server script against the RSSD:

$SYBASE/RAX-15_5/scripts/oracle/ hds_oracle_remove_flashback_errors.sql