cancel
Showing results for 
Search instead for 
Did you mean: 

oracle db link

SOLVED
Go to solution
Vogra
Regular Advisor

oracle db link

Hi All,
when I make dblink (nt4.0 - O8i 8.1.6), I list the following:
OWNER DB_LINK
PUBLIC VSDB.US.ORACLE.COM

can anyone help me?
thanx.
We are spirits in the material world
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: oracle db link

 
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Jeanine Kone
Trusted Contributor

Re: oracle db link

It looks to me like the previous reply ought to give you any information you need, but I can't really tell what your question is. It sounds like you have already created your database link (a public database link called vsdbus.oracle.com). I am guessing your list is from a query to dba_db_links?

Are you having problems using the link? Getting error messages?
Vogra
Regular Advisor

Re: oracle db link

Jeanine,
my is that when I query dba_db_links, I see my dblink with domain .US.ORACLE.COM and I don't know where this domain was set. My domain is VSUL...

thanx,
Lima
We are spirits in the material world
Jeanine Kone
Trusted Contributor

Re: oracle db link

The default domain for the database is set in the init.ora file.

If left unset in the init.ora file, it defaults to .world (at least in my version).

You can also set it through "alter database rename global_name to" command.
Jeanine Kone
Trusted Contributor
Solution

Re: oracle db link

I should have mentioned the parameter name in the iinit.ora file. It is db_domain.

The format is:

db_domain = domain