Home » RDBMS Server » Server Administration » problem creating database link...
problem creating database link... [message #54130] Thu, 31 October 2002 01:18 Go to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hello all,
i am giving the following statement...

create database link X
connect to a identified by pass
using 'X';

Error: Loopback database link needs connection descriptor...
Please help me out with the correct syntax

sai
Re: problem creating database link... [message #54134 is a reply to message #54130] Thu, 31 October 2002 06:02 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sai,
   are u trying to create a dblink to the same database
   but pointing a different schema???
   in that case, add your global_name too.
   soemthing like,

   create dabatase link mydb.mydomain.com 
   connectscott   identified by tiger
   using 'mydb.mydomain.com' ;

   else
   create another connectstring(to the same db) and
   try the same
 

Previous Topic: DBA books
Next Topic: How to insert into remote schema table
Goto Forum:
  


Current Time: Thu Sep 19 18:09:43 CDT 2024