You can create as many dblinks as you want provided
that the dblink name is the same as the global name of the database you connect
to.
In your example:
Create public database link HR connect to HR identified by
pwd_hr using whatever;
You can find the global name of the database by: select *
from global_name; .
Yechiel Adar
Mehish
|
Title: How to create two db-links within one schema when global_names=true?
- How to create two db-links within one schema when global... Daiminger, Helmut
- RE: How to create two db-links within one schema wh... Stephane Faroult
- Re: How to create two db-links within one schema wh... Yechiel Adar
- Re: How to create two db-links within one schema wh... Jonathan Lewis