OraFAQ Forum: Server Administration » dblink in the same server

Home » RDBMS Server » Server Administration » dblink in the same server (oracle 10g, sun solaris.)

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

dblink in the same server [message #528703]

Wed, 26 October 2011 08:29

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?

Report message to a moderator

Re: dblink in the same server [message #528704 is a reply to message #528703]

Wed, 26 October 2011 08:30

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

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Re: dblink in the same server [message #528823 is a reply to message #528704]

Thu, 27 October 2011 06:16

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.

Report message to a moderator

Re: dblink in the same server [message #528861 is a reply to message #528823]

Thu, 27 October 2011 08:29

joy_division
Messages: 4963
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.

Report message to a moderator

Re: dblink in the same server [message #528869 is a reply to message #528861]

Thu, 27 October 2011 08:46

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

Senior Member
Account Moderator

Or even to the same schema...

Regards
Michel

Report message to a moderator

Re: dblink in the same server [message #528898 is a reply to message #528869]

Thu, 27 October 2011 10:39

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.

Report message to a moderator

Re: dblink in the same server [message #528908 is a reply to message #528898]

Thu, 27 October 2011 11:18

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

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

Report message to a moderator

Re: dblink in the same server [message #528964 is a reply to message #528908]

Thu, 27 October 2011 14:57

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

Senior Member
Account Moderator

I always thought that you, French, are strange. Kind of. /forum/fa/917/0/

Report message to a moderator

Previous Topic:	table size
Next Topic:	Should we upgrade from 10g to 11g?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:44:50 CST 2024