The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
1answer
36 views

Golden Gate realtime replication basic question

I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 ...
1
vote
0answers
58 views

Can two transactions share the same SCN?

Do all transactions have a unique SCN? Can two transactions share an SCN? I'm confused by this statement in the Oracle Golden Gate manual: The CSN is cross-checked with the transaction ID ...
0
votes
0answers
54 views

GoldenGate: How to encode Oracle RAW columns as hex strings?

I am using GoldenGate to extract an Oracle table that contains RAW data. The destination is a flat CSV file. How can I encode the RAW columns to hex strings so that they can be written to the CSV ...
0
votes
0answers
99 views

Golden Gate replication from primary to secondary database, WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rgg1ab.prm: SQL error 1403

I am using golden gate to replicate data from primary(Oracle) to secondary (Oracle). I have inserted records in the primary database, but replication abdends with error message WARNING OGG-01154 ...
0
votes
0answers
34 views

GoldenGate: API to read trail files?

Is there an API to read GoldenGate Trail files? I would like to write my own adapter which reads a trail file and updates the state of an internal proprietary system.
0
votes
0answers
60 views

Integrated Extract: what does LogMiner Reader, Preparer and Builder do Exactly?

Have been pouring over Oracle GoldenGate documentations regarding Integrated Extract process. My understanding is that LogMiner Server LMx processes are now responsible for producing LCRs that Local ...
0
votes
0answers
149 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...