Home » RDBMS Server » Server Administration » db link
db link [message #63126] Mon, 13 September 2004 04:18 Go to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi all

i have created database link to make a remote connection and all the service names are existing on tnsname.ora files but when i am using database link in a query to access the remote data

i am getting a following error messages

ORA-02019: connection description for remote database not found

how to rectify this

Regards

dilip

 

 

 

 

Report message to a moderator

Re: db link [message #63127 is a reply to message #63126] Mon, 13 September 2004 05:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the dblink was not created properly.
Please Post the ddl.

Report message to a moderator

Re: db link [message #63130 is a reply to message #63127] Mon, 13 September 2004 07:36 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
create database link test
connect to current_user
using 'test1'

test1 is a valid service name

Report message to a moderator

Re: db link [message #63172 is a reply to message #63130] Wed, 15 September 2004 22:21 Go to previous message
easywebtech
Messages: 20
Registered: August 2004
Junior Member
first current_user should be in target database

create PUBLIC database link test
connect to current_user IDENTIFIED BY [[password]]
using 'test1'

webmaster
www.easywebtech.com

Report message to a moderator

Previous Topic: patchset 8.1.7.4.16
Next Topic: Arabic (Urgent)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 03:34:40 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.