Data Loding by using database link.
685503Sep 21 2010 — edited Sep 28 2010Dear 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