Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> (no subject)

(no subject)

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 13 Mar 2001 02:42:09 -0800
Message-ID: <F001.002CA998.20010313021539@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US