Table marking behavior has changed when you specify the owner of a table in a replication definition. Now, you must always use the owner keyword if you want to enable the SEND OWNER mode. When marking, if you do not specify the replicate owner, it defaults to the primary owner.
In the following examples, the leading letter indicates either primary (p) or replicate (r):
Example 1:
pdb_setreptable ptable, rtable, mark, owner
The table in the replication definition will be:
powner.rtable
Example 2:
pdb_setreptable ptable, rowner.rtable, mark,owner
The table in the replication definition will be:
rowner.rtable
Example 3:
pdb_setreptable ptable, rowner.rtable, mark
The table in the replication definition will not be owner-qualified:
rtable
For additional information, see the Replication Agent Reference Guide.
