Data Loding by using database link.

685503

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 [email protected]_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 [email protected]_DB does not exist in target database.


please advice...
thanks in advacne...
Zakeer Hussain
[email protected]
cell No +91-9886006549

-joe

Zakeer,

You have two choices. First choice is what you're doing but your syntax is off. It should be:

REPLICAT load6
USERID [email protected]_db, PASSWORD sh
ASSUMETARGETDEFS
MAP sh.products, TARGET sh.products;

Second choice is to create a view on the source using the database link to the target and then just map the view as in:

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

Good luck,
-joe

-joe

Zakeer,

You have two choices. First choice is what you're doing but your syntax is off. It should be:

REPLICAT load6
USERID [email protected]_db, PASSWORD sh
ASSUMETARGETDEFS
MAP sh.products, TARGET sh.products;

Second choice is to create a view on the source using the database link to the target and then just map the view as in:

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

Good luck,
-joe

685503

Dear Joe,

Thanks for your response.