Allows replication definitions to be automatically created and dropped at Replication Server for tables and procedures when they are marked and unmarked for replication.
false
true – Replication definitions are automatically created at the Replication Server when tables or procedures are marked.
false – No replication definitions are created when tables or procedures are marked.
When this property is set to true:
The pdb_setreptable is invoked to mark a table or tables, and a replication definition is created at Replication Server for each table that is marked for replication.
The pdb_setrepproc is invoked to mark a procedure, and a replication definition is created at Replication Server for each procedure that is marked for replication.
The pdb_setreptable is invoked to unmark a table, and the replication definition is dropped at Replication Server for each table that is unmarked for replication.
The pdb_setrepproc is invoked to unmark a procedure or procedures, and a replication definition is dropped at Replication Server for each procedure that is unmarked for replication.
The pdb_xlog is initialized and table auto-marking is enabled, and a replication definition is created for each table that is marked for replication.
Replication definition names for tables always begin with the prefix ra$, followed by an alphanumeric value and the replicate table name. (See the following examples.) All non-alphanumeric characters except the underscore and period are removed from the replicate table name. The period (".") is converted to an underscore, and the resulting name is truncated, if necessary, to 24 characters, (repdef names are limited to 30 characters.)
The following table identifies examples of replicate names and their resultant repdef names.
Table name |
Replication definition name |
|---|---|
order$req |
ra$0x794a_orderreq |
orderreq |
ra$0x7952_orderreq |
my.orderreq |
ra$0xa154_my_orderreq |
A replication definition name for a procedure is the same name as the procedure.
