Skip to Content
author's profile photo Former Member
Former Member

How to read the source table using a dblink in oracle


I want to read data from a source table which I can access using dblink in the datawarehouse. I tried different things in DI and I don't know how to do that? Can any one help me on this?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 11, 2008 at 02:37 PM

    you can do it the same way you do it in the target database.

    put the ip of ther server in the system files

    if you use windows go to system32/driverse/etc

    edit the file hosts and add the ip and the name of the source database machine

    lets say mydb.mydomain.xx

    now in the target database you can select any data from the source database

    select * from mytable (at)mydb.mydomain.xx

    you can use all the tables like the same way

    im working in that since a long time

    note i couldnt write @ , so i did it (at)

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 17, 2008 at 09:49 AM

    Two options:

    First you could create a view in the dwh database that is using that remote link: create or replace view r_source as select * from source@dblink.

    Better option is to create the source system datastore - but I assume that exists already - and then go to the dwh datastore and say that there is a dblink of a given name with which the target database can read from the other database. DI then will execute a from source@dblink kind of statement whenever that is possible. In case no such full pushdown is possible and the data is going through the DI engine anyway, reading via the dblink does not make sense anyway.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.