Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creation of database link

Status
Not open for further replies.
AQWQ

AQWQ

Programmer
Aug 5, 2001
33
IN
I have two oracle servers.I am not able to create a database link to the other one, but i am able to setup TNS service and connect to the other server.While creating the database link to the other server its getting created successfully.But when try to access the table in that server using the link name its giveing an error saying &quot;<linkname> connects to oracle.world&quot;.Any idea????

Thanx in advance Santhosh Ravindran
 
Sort by date Sort by votes
The fact your database link is created successfully means only that your sql statement is syntactically correct. Do you use global_names=true ? Do you use the same connect string for connecting from sql*plus and creating db_link?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hipath4k
  • Locked
  • Question
Share link to download Orcale 10 G
Replies
0
Views
156
hipath4k
hipath4k
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
747
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in &quot;Description&quot; column of &quot;AP_INVOIC 2
Replies
5
Views
290
Livia8
Livia8
torturedmind
  • Locked
  • Question
Week of the year
Replies
0
Views
149
torturedmind
torturedmind
Livia8
  • Locked
  • Question
Generate report/output on the basis of &quot;enquiry&quot; responsibilities only 1
Replies
16
Views
284
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top