Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)
You
can simply do an export/import to achieve this. Make sure that you create the
table structures in your third database as they are in the first and second. If
you have any more specific questions about the actual export/import procedure,
then send them as they occur, as we could write a manual
here..
<SPAN
class=027310510-13032001>HTH
<SPAN
class=027310510-13032001>
<SPAN
class=027310510-13032001>Mark
<FONT face=Tahoma
size=2>-----Original Message-----From: root_at_fatcity.com
[mailto:root_at_fatcity.com]On Behalf Of andreySent: Tuesday,
March 13, 2001 09:31To: Multiple recipients of list
ORACLE-LSubject: FW:
<SPAN
class=481232009-13032001>Dear list !
<SPAN
class=850551904-10032001>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.
<SPAN
class=850551904-10032001>The query is simple select
statement.
<SPAN
class=850551904-10032001>
<SPAN
class=850551904-10032001>Early help would be
appreciated.
<SPAN
class=850551904-10032001>
<SPAN
class=850551904-10032001>REgards,
<SPAN
class=850551904-10032001>Rajan
Received on Tue Mar 13 2001 - 04:42:09 CST
![]() |
![]() |