Re: dblink

1. If global_name is set true in both the instances to TRUE then u have to create the DBlink with same Global database name.
2. In server1 create a net service name to connect to server2 Database(my_Db). eg.easy to notify server2 as the service name
3. Create a db link in server1

create [public] db link MY_DB connect to my_user identified by <my_user password> using 'server2'

Try from sqlplus server1> select table_name from user_Tables_at_MY_DB--> dblink name.(what ever the query you want)

To avoid confusions etc normally I will set GLOBAL_NAMES=false, so that we can create the db link name what ever we want.

"lif" <t_at_i.gb> wrote in message news:a5ni92$1h0k$1_at_news5.isdnet.net... Hi,

I'm newbi in oracle

May be a stupid question for you....:

I've got a server1 with a DB name my_db and a user my_user I've got a server2 with a DB name my_db and a user my_user (same db_name and user name on 2 differents servers)

parameters :
Global_name option is TRUE
Same DB_name

I need to create a dblink between the 2 DB how can i do ?

Win NT
Oracle8.1.7

Thanx. Received on Fri Mar 01 2002 - 06:59:09 CST