Home » RDBMS Server » Server Administration » dblink in the same server (oracle 10g, sun solaris.)
dblink in the same server [message #528703] Wed, 26 October 2011 08:29 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Is it possible to create a dblink for another database which is present in the same server as the source?
Re: dblink in the same server [message #528704 is a reply to message #528703] Wed, 26 October 2011 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 59502
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: dblink in the same server [message #528823 is a reply to message #528704] Thu, 27 October 2011 06:16 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
DB link is to connect from one database to another database. It does not matter if it is same or different server.
Re: dblink in the same server [message #528861 is a reply to message #528823] Thu, 27 October 2011 08:29 Go to previous messageGo to next message
joy_division
Messages: 4532
Registered: February 2005
Location: East Coast USA
Senior Member
ridhi_sundar wrote on Thu, 27 October 2011 07:16
DB link is to connect from one database to another database. It does not matter if it is same or different server.


Not accurate. You can make a db link to connect to another schema in the same database.
Re: dblink in the same server [message #528869 is a reply to message #528861] Thu, 27 October 2011 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 59502
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or even to the same schema...

Regards
Michel
Re: dblink in the same server [message #528898 is a reply to message #528869] Thu, 27 October 2011 10:39 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
@Joy

Obviously you can. But you never need to use.You would not use a telephone to call your colleague sitting next to your desk.
Re: dblink in the same server [message #528908 is a reply to message #528898] Thu, 27 October 2011 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 59502
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You would not use a telephone to call your colleague sitting next to your desk

Wouldn't you? It happens at my office!

Regards
Michel
Re: dblink in the same server [message #528964 is a reply to message #528908] Thu, 27 October 2011 14:57 Go to previous message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I always thought that you, French, are strange. Kind of. ./fa/917/0/
Previous Topic: table size
Next Topic: Should we upgrade from 10g to 11g?
Goto Forum:
  


Current Time: Fri Oct 31 02:18:43 CDT 2014

Total time taken to generate the page: 0.06092 seconds