(Oracle and UDB only) Determines whether replication is enabled by default when objects (tables or stored procedures) are marked.
true – enables replication by default (automatically) when objects are marked.
false – disables replication by default when objects are marked.
If the value of the pdb_dflt_object_repl parameter is false when a table is marked for replication, no transactions can be replicated from that table until replication is explicitly enabled with the pdb_setreptable command.
If the value of the pdb_dflt_object_repl parameter is false when a stored procedure is marked for replication, no invocations of that stored procedure can be replicated until replication is explicitly enabled with the pdb_setrepproc command.
You can use the pdb_setrepproc or pdb_setreptable command to enable or disable replication for all marked stored procedures or tables at once.
When replication is disabled for a table, no operations that affect that table will be recorded in the transaction log.
When replication is disabled for a stored procedure, no invocations of that stored procedure are recorded in the transaction log.
For Microsoft SQL Server, the pdb_setrepproc command ignores the pdb_dflt_object_repl parameter. As a result, pdb_setrepproc always enables replication by default when objects are marked.