When a primary table is marked for replication, Replication Agent creates a shadow table to record the replicated operations. The shadow table has all the columns of the primary table, plus three special columns that Replication Agent creates for its use:
RA_TRAN_ID_
RA_OP_ID_
RA_IMG_TYPE_
These column names are fixed, not generated, therefore
the “RA_” portion of the variable name
does not change when the value of the pdb_xlog_prefix parameter
changes.
If a primary table has a column with the same name as a Replication Agent shadow table special column, the table marking procedure fails. Replication Agent flags the conflicting column in the table-marking script and the pdb_setreptable command returns an error.
In this event, you must change the name of the conflicting column in the primary table.
You cannot use these names as names for replicate columns in the replicate database, unless you create function strings to modify the replicated transactions before they are applied to the replicate database.
If you elect to change the name of the conflicting column in the primary table, you can modify the table-marking script and run it manually to mark the primary table.
If you want to use the original column name in the replicate table, you can create a function string in the replicate Replication Server to map the new column name in the primary table to the original column name in the replicate table.
