database links [message #876] |
Sun, 10 March 2002 23:03 |
sethu_raman
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Hi all,
i have two databases a and b. i want to select tables from databse b and from database b i want select tables from database a. i have created database links on both the databases, but i get the error as
ora-12154:tns:counld not resolve service name
during selecting from the table which is present in database b.
can any one help me please.
thanks in advance
sethuraman.r
|
|
|
Re: database links [message #877 is a reply to message #876] |
Sun, 10 March 2002 23:41 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
This problem is in tnsname.ora. You need to tnsping on database a and database b server.
e.g
1. In database server a -> tnsping database b
2. In database server b -> tnsping database a
If tnsping is worked then please check setting on database link in database (dba_db_links). Hope this is helping. Thank
|
|
|
Re: database links [message #883 is a reply to message #876] |
Mon, 11 March 2002 04:09 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
You do not need database links if they are on the same server. Grant access to the tables you want to update, insert, select, or delete. Then reference them like SQL> select * from aschema.tablename. If you do not want to preface the tablename with the schema create a synonym.
|
|
|
Re: database links [message #1272 is a reply to message #876] |
Tue, 16 April 2002 05:09 |
GopalSethuraman
Messages: 2 Registered: April 2002
|
Junior Member |
|
|
since u have both the databases on the same server b4 using the dblink
set the oracle_sid as the particular db u want it the copy to be done on.
Hope this should solve the problem
|
|
|