OraFAQ Forum: Server Administration » how can i link two databases

Home » RDBMS Server » Server Administration » how can i link two databases

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

how can i link two databases [message #196938]

Mon, 09 October 2006 04:52

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hello Everyone,

I am having two databases running on a single machine[Accounts & sales], How can i access the Accounts DB from Sales DB ...how can i link two databases

win 2000 server
Oracle 9.2

Thanks in Advance

Report message to a moderator

Re: how can i link two databases [message #196939 is a reply to message #196938]

Mon, 09 October 2006 05:04

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Use a database link.

Report message to a moderator

Re: how can i link two databases [message #196957 is a reply to message #196938]

Mon, 09 October 2006 06:08

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

I have gone thru the documentation. My question is
suppose I have one DB as Accounts n Another as Sales.
in Sales, i have a schema Accountant
& in Accountant schema i have a table acct_2006.

Now?

from the sales DB how can i access the acct_2006 table
what will be the link for that?

if i will create a link as

CREATE PUBLIC DATABASE LINK remote
USING 'Accounts';

how can i be able to access acct_2006

Appreciating your response

Report message to a moderator

Re: how can i link two databases [message #196968 is a reply to message #196957]

Mon, 09 October 2006 06:48

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Sorry, kinda confused as to your requirements. You mention the ACCT_2006 table is in the SALES database, but then mention "how do i access the ACCT_2006 table from the sales database"??

I'll assume you want to access ACCT_2006 that is in the ACCOUNTS database from the SALES database. You'd create a database link in the SALES datbase as:

create database link remote
connect to accountant identified by password
using 'account_tns';

where account_tns is the actual tns alias you use to connect to the ACCOUNTS database from the SALES database.

Report message to a moderator

Re: how can i link two databases [message #196974 is a reply to message #196938]

Mon, 09 October 2006 07:30

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thankyou very much Laughing

Report message to a moderator

Previous Topic:	Implementing a version control mechanism
Next Topic:	database clonnig (urgent)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:41:57 CDT 2024