CODEWITHSUNDEEP
oracle-databasedblinkdatabase-link
mysticfalls
mysticfalls

Reputation: 455

Can you create dblink for the same database you are connected?

I know this is kind of weird but I would just like to know how this was being setup. There are two database and they are the same (one is mirror from the other). The first db is named "reportsdw" and the other one is "reportsdwx". I tried to "select * from dual@reportsdw" on reportsdw db and it worked, but when I did this "select * from dual@reportsdwx" on reportsdwx it is not working. Can anyone explain that?

Upvotes: 1

Views: 2742

Answers (1)

steve
steve

Reputation: 6020

It is possible, but you have to create the corresponding database links.

Upvotes: 2

Related Questions