(no subject)

From: Sonja Šehovic <sonja.sehovic_at_pbz.hr>
Date: Tue, 13 Mar 2001 07:30:06 -0800
Message-ID: <F001.002CAC12.20010313054608@fatcity.com>

Try with
copy.
You can do it
like:
<SPAN

class=132344013-13032001> 
COPY FROM
database TO database action -  destination_table (column_name, column_name, -  column_name ...) USING query
<SPAN

class=132344013-13032001> 
For
instance:
<SPAN

class=132344013-13032001>    copy from
scott/tiger_at_db1-    to scott/tiger_at_db2-    create aa_new using select * from aa;
<SPAN

class=132344013-13032001>or
<SPAN

class=132344013-13032001>    copy from 
scott/tiger_at_db1-t    o 
scott/tiger_at_db2-i    nsert aa_new using select * from 

aa;
<SPAN

class=132344013-13032001> 
<SPAN

class=132344013-13032001>HTH,
<SPAN

class=132344013-13032001>    Sonja

  <FONT face=Tahoma
  size=2>-----Original Message-----From: andrey   [mailto:bronfin_at_visualtop.com]Sent: Tuesday, March 13, 2001 10:31   AMTo: 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 - 09:30:06 CST