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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
