Configuration as follows:
sp_ctrl (spdl05:2100)> help target set metadata
Configuration: metadata to be updated on the target
Usage: target {target} [queue {queuename}] set metadata {metadata list}
target {target} [queue {queuename}] reset metadata
target {target} [queue {queuename}] show metadata
Keyword Column type Default column name Description
---------- ------------ ------------------------------ --------------------------------------------------
time TIMESTAMP SHAREPLEX_SOURCE_TIME Time operation applied on source
userid NUMBER SHAREPLEX_SOURCE_USERID User ID that performed operation
op VARCHAR2 SHAREPLEX_SOURCE_OPERATION Type of operation (INSERT, UPDATE, DELETE, ...)
scn NUMBER SHAREPLEX_SOURCE_SCN Source SCN when operation was applied
rowid ROWID SHAREPLEX_SOURCE_ROWID ROWID of row that changed
trans VARCHAR2 SHAREPLEX_SOURCE_TRANS Transaction ID for the operation
seq NUMBER SHAREPLEX_OPERATION_SEQ Operation order within transaction
host VARCHAR2 SHAREPLEX_SOURCE_HOST Source host
queue VARCHAR2 SHAREPLEX_QUEUENAME Queue name
source VARCHAR2 SHAREPLEX_SOURCE_ID User defined source identifier
Example:
On Target :
target o.<SID> set metadata time
demo_dest table should have an extra column SHAREPLEX_SOURCE_TIME of datatype TIMESTAMP to enable this replication.
