Home » SQL & PL/SQL » SQL & PL/SQL » How to Create Database Link In Oracle 8.1.7
How to Create Database Link In Oracle 8.1.7 [message #633033] Tue, 10 February 2015 06:22 Go to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
when i apply this command in 10g then it works very well

create database link faheem connect to account identified by a using 'main'

but when i apply this in Oracle 8.1.7 Then Database link created but following error appear after this command

select * from tab@faheem

*
ERROR at line 1:
ORA-02085: database link FAHEEM.US.ORACLE.COM connects to ORCL.US.ORACLE.COM

Kindly me guide me what is the solution

Regards

Faheem

Report message to a moderator

Re: How to Create Database Link In Oracle 8.1.7 [message #633034 is a reply to message #633033] Tue, 10 February 2015 06:24 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
You need to read up on the instance parameter GLOBAL_NAMES.

Report message to a moderator

Re: How to Create Database Link In Oracle 8.1.7 [message #633040 is a reply to message #633033] Tue, 10 February 2015 06:35 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 

ORA-02085: database link %s connects to %s
 *Cause: a database link connected to a database with a different name.
  The connection is rejected.
 *Action: create a database link with the same name as the database it
  connects to, or set global_names=false.

Report message to a moderator

Previous Topic: split a number or dates by slab (merged)
Next Topic: numeric value error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 02:15:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.