How do I carry forward a capture process extra attribute in a CDC environment.
edited Feb 17, 2010 10:05PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
Hello,
I have pair of Oracle 10g databaes that have CDC asynchronous hotlog replication set up on them. On the source database, I have added the tx_name extra attribute, DBMS_CAPTURE_ADM.INCLUDE_EXTRA_ATTRIBUTE. I want to carry the value of this attribute forward into the apply process and change tables on the destination database.
I have found plenty of documentation on how to retrieve the value from the Capture LCR, but I can't find anything on how to carry the value forward and put it on the change tables as a regular table column.
I have pair of Oracle 10g databaes that have CDC asynchronous hotlog replication set up on them. On the source database, I have added the tx_name extra attribute, DBMS_CAPTURE_ADM.INCLUDE_EXTRA_ATTRIBUTE. I want to carry the value of this attribute forward into the apply process and change tables on the destination database.
I have found plenty of documentation on how to retrieve the value from the Capture LCR, but I can't find anything on how to carry the value forward and put it on the change tables as a regular table column.
I have tried to set up a DML Handler procedure on the Apply database and am using the lcr.get_extra_attribute function to get the value of the extra attribute, but it doesn't look like the procedure is begin executed.
0