OraFAQ Forum: SQL & PL/SQL » How to Create Database Link In Oracle 8.1.7

Home » SQL & PL/SQL » SQL & PL/SQL » How to Create Database Link In Oracle 8.1.7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Create Database Link In Oracle 8.1.7 [message #633033]

Tue, 10 February 2015 06:22

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

John Watson
Messages: 9003
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

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 27 00:38:32 CDT 2026