GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Logminer dictionary concept for golden gate extract

edited Jun 9, 2020 3:33AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

We are trying to setup GG extract to replicate some data. When we register an integration extract, behind the scene, it dumps the "logminer dictionary" in the logfile and we can query v$archived_log.dictionary_begin and dictionary_end columns to find out when the dictionary was created.

Let say my archive seq number 100 has the dictionary, does this mean we have to keep this or all of the following archivelogs for GG extract parsing? If not then it means the dictionary is not stored in logfile, correct?

If the dictionary is in archive seq 100 and later i create a new table in DB then how that will become part of the dictionary? Do I have to re-generate dictionary after every DDL?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center