Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data dictionary and GoldenGate Integrated Extract

user9527632Sep 3 2017 — edited Sep 3 2017

How does GoldenGate maintain and use Data Dictionary?  For example, I set up a locally Integrated extract.  I understand GG will build a dictionary for this IE.  So at this very moment, this dictionary and on-line data dictionary are in sync.

Suppose in both dictionary, I have   tableA(columnA   number(1)) and tableB.    Now,  I just stopped my IE for a while,  during the time,  some DML performed    in the database,  then I altered columnA to  columnA number(5)   and added another tableC,  renamed tableB  to tableX.  after that I performed more DML.   Now I re-started  IE,   if I saw columnA ,  how does GG know if it's number(1) or number(5),    if it seems tableC,  it is not in the dictionary IE built when IE was created, so it must use the on-line DD?

It is quite confusing and I cannot find any document on this. It seems to me GG must have maintained some kind of multi-version DD and also use on-line DD,  it is just smart enough to know which one to use.

I want to hear what you think.  Thank you!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2017
Added on Sep 3 2017
5 comments
2,225 views