Extract Datas from Oracle to .. Oracle

[Benouche]

Hello,

i need to extract (doing some aggregation) a table from an Oracle database to load it to another Oracle db.

How can I do it ?

Any easy/quick solution hotly welcome !!!

Benouche

 

[sem]

You may use export/import. If they're connected via dblink, you may also use COPY or CREATE AS SELECT commands.

 

[Turkbear]

Hi,
If you want to do some aggregation first, then exp/imp are not what you want to use..create a view with the aggregation you want, then use the

Create table@otherinstanceusingdblink 
as select * from Thisnewviewname;
[code]
where  [i]otherinstanceusingdblink [/i]is a pre-created database link using a connection that can create tables in the remote instance.

[profile]