Generate Replication Definitions When Primary and Replicate Table Schemas are Different

Use rs_repdef_schema_map before generating replication definitions if the primary and replicate table schemas are different.

In earlier versions, if the primary and replicate table schemas were different, you had to manually create replication definitions. Now, you can use rs_repdef_schema_map with the add option before using these commands to generate replication definitions:

rs_create_repdef
pdb_setreptable when the configuration parameter pdb_auto_create_repdefs is true.

See Replication Agent Reference Manual.

Example:

If user1 is the primary table schema and user2 is the replicate table schema, execute rs_repdef_schema_map with the add option:

rs_repdef_schema_map add, user1, user2

For any automatically generated replication definition, Replication Agent generates the syntax:

create replication definition [replication_definition_name]
with primary at [primary_database_name]
with primary table named user1.primary_table_name
with replicate table named user2.primary_table_name