rs_repdef_schema

Returns the current replication definition schema map, adds a replication schema map, or removes a replication schema map.

Syntax

rs_repdef_schema_map [add, primary_schema, replicate_schema] | [remove, primary_schema]

Parameters

add – Adds a single schema map from the primary table schema to the replicate table schema.
primary_schema – The schema of the primary table.

replicate_schema – The schema of the replicate table.

remove – Removes a single schema map used for generating replication definitions.

Examples

Example 1 –
```
rs_repdef_schema_map
```
This command returns the current replication definition schema map.
Example 2 –
```
rs_repdef_schema_map add, user1, user2
```
This command adds a replication schema map from the primary schema user1 to the replicate schema user2.
Example 3 –
```
rs_repdef_schema_map remove, user1
```
This command removes a replication schema map specified by primary schema user1.

Usage

When the primary and replicate table schemas are different, use the rs_repdef_schema_map before generating replication definitions using these commands:

rs_create_repdef
pdb_setreptable with the configuration parameter pdb_auto_create_repdefs set to true.

For 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