Re: Database link

From: <oracle_rahul_at_my-deja.com>
Date: Tue, 21 Sep 1999 18:13:22 GMT
Message-ID: <7s8hrk$nkj$1@nnrp1.deja.com>

Hello

1) Database link is the one path communication.
2) The name of both the database's should be different .
3) suppose u have database vca and database ppb
4) Do the changes in the tnsnames.ora

specifiy the ppb.world string in vca database tnsnames. specifiy the vca.world string in ppb.world database tnsnames.

5) issue a statement from vca database

create database link ppb.world connect to scott/tiger using
"ppb.world"

In the same manner specify another statment from different database

create database link vca.world connect to scott/tiger using
"vca.world"

Your problem will be solved.
If any problem mail me at following address :-

oracle_server_at_hotmail.com

Rahul
ORACLE DBA
ESSAR CELLPHONE LTD
DELHI(INDIA Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 13:13:22 CDT