New answers tagged goldengate
What OGG version are you using? Instead of DBA role, have you tried granting the required privileges through dbms_goldengate_auth.grant_admin_privilege? "Requirements When Configuring Extract or Replicat in Integrated Mode (Oracle) If using DBLOGIN to issue ADD EXTRACT, ALTER EXTRACT, or REGISTER EXTRACT to initiate integrated capture or ADD REPLICAT, ...
I came to know from Oracle, inserting a sequence is possible with inserting the same sequence at the source as well, called cyclic sequence. For more details check the MOS doc "Implementing replication of cyclic sequences in GoldenGate (Doc ID 1321558.1)".
Top 50 recent answers are included