Home » RDBMS Server » Server Administration » Database Links
Database Links [message #372473] Wed, 14 February 2001 08:26 Go to next message
Kenneth Acosta
Messages: 1
Registered: February 2001
Junior Member
I am creating a db link on Oracle 7.3. I create the db link with the same name as the database but I am still getting

ORA-2085: database link name.world connects to name

error. This probably can be corrected if my global names was set to false but I do not want to change this setting. My syntax to create the db link is

CREATE PUBLIC DATABASE LINK nameofdb
CONNECT TO userid IDENTIFIED BY useridpassword
USING 'nameofdb';

What else can I do???
Re: Database Links [message #372475 is a reply to message #372473] Wed, 14 February 2001 10:42 Go to previous message
Boris
Messages: 5
Registered: February 2001
Junior Member
1. try: CREATE PUBLIC DATABASE LINK nameofdb.WORLD....

2. check the set of privileges
Previous Topic: Selecting the latest row with same time stamp..
Next Topic: Update Query
Goto Forum:
  


Current Time: Mon Dec 23 01:34:36 CST 2024