RE:

[Sonja Šehovic]

Try with copy.

You can do it like:

 

COPY FROM database TO database action -
  destination_table (column_name, column_name, -  column_name ...) USING query

 

For instance:

    copy from scott/tiger@db1-
    to scott/tiger@db2-
    create aa_new using select * from aa;

or

    copy from scott/tiger@db1-
t    o scott/tiger@db2-
i    nsert aa_new using select * from aa;

 

HTH,

    Sonja

-----Original Message-----
From: andrey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
Subject: FW:

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