Skip to Main Content
Forums

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!

Oracle Golden Gate Source DB Read Only

FreiburgBillNov 28 2017 — edited Nov 29 2017

I am trying to use GoldenGate to connect a read-only MSSQL-DB to an Oracle-DB.

In ggsci when I try the command for the MSSQL source DB:  ADD TRANDATA MySchema.TableName

I get lots of errors because the db is read-only and it looks like the command is trying to add a gg table OracleGGCreateNextBatch to my source schema.

Is there a way to put this table in another schema that is not read-only??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2017
Added on Nov 28 2017
#goldengate
2 comments
458 views