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!

Invalid option for MAP: COLMAP(. - on a REPLICAT

901176Nov 20 2011 — edited Aug 13 2012
Using GOldenGate 11.1, replicating from an Oracle 11G to an Oracle 11G on the same box (no datapump). Many tables, but the target always has two more columns. The source is built by the application, and the target is generated from a DIFF of the source, thus the sequence of the columns will differ.

I have found that I need a SOURCEDEFS and have generated that for all the source tables. I believe I need a least a MAP SOURCE=xxx, TARGET= yyy, COLMAP=(USEDEFAULTS); at the very least. I plan on gettint the source action type and source commit time from the header, but won't add that until I can get the basics working.

No matter what I do, I continue to get OGG-00212 Invalid option for MAP: COLMAP(. What am I doing wrong?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2012
Added on Nov 20 2011
#goldengate
9 comments
2,018 views