OraFAQ Forum: SQL & PL/SQL » Db link name problem

Home » SQL & PL/SQL » SQL & PL/SQL » Db link name problem (Oracle 10.2.0 & Solaris 10)

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

Db link name problem [message #298398]

Wed, 06 February 2008 00:57

sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai

Junior Member

Hi All
I have created db link with the name "TEST",
but after creation I found the same as follows

TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM

can you please tell me this is why ?

thanks

sv

Report message to a moderator

Re: Db link name problem [message #298434 is a reply to message #298398]

Wed, 06 February 2008 02:01

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

Senior Member
Account Moderator

db_domain is added to database link name.

Regards
Michel

Report message to a moderator

Re: Db link name problem [message #298493 is a reply to message #298434]

Wed, 06 February 2008 04:14

sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai

Junior Member

Hi thnaks for immediate reply.
But my data base has not set any domain.

Report message to a moderator

Re: Db link name problem [message #298494 is a reply to message #298493]

Wed, 06 February 2008 04:18

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

Senior Member
Account Moderator

post "show parameter db_domain"
Post the statement you executed to create db link.

Regards
Michel

Report message to a moderator

Re: Db link name problem [message #298495 is a reply to message #298493]

Wed, 06 February 2008 04:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does

SELECT * FROM global_name;

say?

Report message to a moderator

Re: Db link name problem [message #298505 is a reply to message #298495]

Wed, 06 February 2008 04:36

sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai

Junior Member

thanks ,

How can I change my Global database name ?

Report message to a moderator

Re: Db link name problem [message #298506 is a reply to message #298505]

Wed, 06 February 2008 04:37

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

Senior Member
Account Moderator

Please, first, post what is asked.

Regards
Michel

Report message to a moderator

Re: Db link name problem [message #298518 is a reply to message #298506]

Wed, 06 February 2008 04:51

sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai

Junior Member

db_domain = ""

Report message to a moderator

Re: Db link name problem [message #298533 is a reply to message #298518]

Wed, 06 February 2008 05:28

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

Senior Member
Account Moderator

This is not an output from a query or command.
COPY AND PASTE your execution for the 3 requested commands and FORMAT them: please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Db link name problem [message #298814 is a reply to message #298398]

Thu, 07 February 2008 15:28

Bill B
Messages: 1971
Registered: December 2004

Senior Member

Unless I am mistaken, oracle uses "REGRESS.RDBMS.DEV.US.ORACLE.COM" as a default domain if one is not specified for the database.

Report message to a moderator

Re: Db link name problem [message #298817 is a reply to message #298814]

Thu, 07 February 2008 15:46

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

Senior Member
Account Moderator

I think I recall this is the case when you create the database using dbca but I never use it (well, only once to get the first template in each version) or OEM.

Regards
Michel

Report message to a moderator

Previous Topic:	Converting a varchar2 to a char
Next Topic:	How many users are connected to the database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 13:30:29 CST 2024