(no subject)

From: Harsh Agrawal <HARSHA_at_Amdocs.com>
Date: Tue, 13 Mar 2001 03:24:22 -0800
Message-ID: <F001.002CA9DB.20010313031028@fatcity.com>

First of all the prequsite is all three must have NWk connectivity.

Create a DB link in Database 3.
i.e. DB Link 1 between DB 3 and DB 1.

DB Link 2 between DB 3 and DB 2.

Now for more simplicity u can create the synonym of table in database 1 and database 2 in database 3.
Now U have both the Virtual tables in database 3.

Use these two tables in DB 3 now.

So the command u will have to go thru are 1. CREATE DATABASE LINK ....
2. CREATE SYNONYM .... In case u don't have link between DBs then u can use export of single tables from DB1 and DB2 and import into to DB3.

That's all.

-----Original Message-----
Sent: Tuesday, March 13, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L

Dear list !

Incase if I've 2 databases with different set of data and I want to extract data from few tables in database 1 and data from few tables in database 2 and put the extracted data into 3rd database how can I do it. The query is simple select statement.

Early help would be appreciated.

REgards,
Rajan

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harsh Agrawal
INET: HARSHA_at_Amdocs.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 13 2001 - 05:24:22 CST