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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data Loding by using database link.

685503Sep 21 2010 — edited Sep 28 2010
Dear All,

I am New to Oracle GoldenGate..

How to use database link in GG??

bellow is the my scenario....


I have one source table in client machine (.28) and i nedd to laod data into target machine (.149) through database link.

i am running GG application in (.28) and create database link called docqvoice_db alos.

i have used bellow extract code also

REPLICAT load6
USERID sh, PASSWORD sh
ASSUMETARGETDEFS
MAP sh.products, TARGET products@docqvoice_db;

i have creates source structure in target also.
i got the error

WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, LOAD5.prm: EXTRACT task LOAD6 abended : Table PRODUCTS@DOCQVOICE_DB does not exist in target database.


please advice...
thanks in advacne...
Zakeer Hussain
zakeer7007@gmail.com
cell No +91-9886006549
This post has been answered by -joe on Sep 22 2010
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 26 2010
Added on Sep 21 2010
#goldengate
2 comments
445 views