Home » RDBMS Server » Server Administration » Connect to other database
Connect to other database [message #52773] Tue, 13 August 2002 00:12 Go to next message
Nishant
Messages: 20
Registered: August 2001
Junior Member
HI,

There are two databases Db1 in vers. 8 and DB2 in ver 9i. both are on different machines.
I want to retrieve or connect to DB2 from DB1 database.
Is it possible? if Yes, how?
Please mail me ASAP.

Nishant

Report message to a moderator

Re: Connect to other database [message #52775 is a reply to message #52773] Tue, 13 August 2002 02:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a dblink.
any book or documentation on oracle would give the basic steps in creating database links(dblink)

Report message to a moderator

Re: Connect to other database [message #52916 is a reply to message #52773] Tue, 20 August 2002 11:05 Go to previous message
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
create a public or private database link

create database link name_of_the_database
connect to scott identified by tiger
using net_service_name_from_the_tnsnames.ora;

Report message to a moderator

Previous Topic: external table - issue (very urgent)
Next Topic: Trigger for populating created date field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 12:09:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.