Home » SQL & PL/SQL » SQL & PL/SQL » Db link name problem (Oracle 10.2.0 & Solaris 10)
Db link name problem [message #298398] Wed, 06 February 2008 00:57 Go to next message
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
Re: Db link name problem [message #298434 is a reply to message #298398] Wed, 06 February 2008 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
db_domain is added to database link name.

Regards
Michel
Re: Db link name problem [message #298493 is a reply to message #298434] Wed, 06 February 2008 04:14 Go to previous messageGo to next message
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.


Re: Db link name problem [message #298494 is a reply to message #298493] Wed, 06 February 2008 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
post "show parameter db_domain"
Post the statement you executed to create db link.

Regards
Michel
Re: Db link name problem [message #298495 is a reply to message #298493] Wed, 06 February 2008 04:18 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does
SELECT * FROM global_name;
say?
Re: Db link name problem [message #298505 is a reply to message #298495] Wed, 06 February 2008 04:36 Go to previous messageGo to next message
sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai
Junior Member

thanks ,

How can I change my Global database name ?
Re: Db link name problem [message #298506 is a reply to message #298505] Wed, 06 February 2008 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please, first, post what is asked.

Regards
Michel
Re: Db link name problem [message #298518 is a reply to message #298506] Wed, 06 February 2008 04:51 Go to previous messageGo to next message
sachin_svaidya
Messages: 15
Registered: March 2006
Location: Mumbai
Junior Member

db_domain = ""

Re: Db link name problem [message #298533 is a reply to message #298518] Wed, 06 February 2008 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Db link name problem [message #298814 is a reply to message #298398] Thu, 07 February 2008 15:28 Go to previous messageGo to next message
Bill B
Messages: 1484
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.
Re: Db link name problem [message #298817 is a reply to message #298814] Thu, 07 February 2008 15:46 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Converting a varchar2 to a char
Next Topic: How many users are connected to the database
Goto Forum:
  


Current Time: Wed Dec 07 20:48:31 CST 2016

Total time taken to generate the page: 0.12646 seconds