Forum Stats

  • 3,874,838 Users
  • 2,266,780 Discussions
  • 7,911,975 Comments

Discussions

Data Loding by using database link.

685503
685503 Member Posts: 59
edited Sep 28, 2010 2:40AM in GoldenGate
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

Best Answer

  • -joe
    -joe Member Posts: 226
    Answer ✓
    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

Answers

  • -joe
    -joe Member Posts: 226
    Answer ✓
    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
    685503 Member Posts: 59
    Dear Joe,

    Thanks for your response.
This discussion has been closed.