Home » RDBMS Server » Server Administration » How Can we connect two databases
How Can we connect two databases [message #495507] Sun, 20 February 2011 02:52 Go to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How Can we connect two databases for example database 1 = orcl and database 2 = orcl1 i want to give selection rights to orcl1 from orcl please guide me how can i manage this issue

regards

Faheem
Re: How Can we connect two databases [message #495510 is a reply to message #495507] Sun, 20 February 2011 03:32 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
Hi, Faheem - you need to read chapter 30 of the 11.2 Administrator's Guide, "Distributed DAtabase Concepts". You probabltyneed to set up a database link,
Re: How Can we connect two databases [message #496044 is a reply to message #495507] Wed, 23 February 2011 23:43 Go to previous messageGo to next message
manishsri0106
Messages: 6
Registered: February 2011
Location: India
Junior Member

Hi

You can use DBLINK in this case.

Regards
Manish
Re: How Can we connect two databases [message #496065 is a reply to message #496044] Thu, 24 February 2011 03:05 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How to create DBLINK in Oracle 8i,9i
Re: How Can we connect two databases [message #496066 is a reply to message #496065] Thu, 24 February 2011 03:12 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://tahiti.oracle.com
- click on your version number
- click on SQL Reference
- go to CREATE DATABASE LINK page

Regards
Michel
Previous Topic: Oracle 10.2.0.5 patch
Next Topic: Dynamic registration of Listener
Goto Forum:
  


Current Time: Wed May 08 15:11:28 CDT 2024