I want to unload data from table in oracle to table in anothe
database,for example DB2

Can you help me with a sample code
thanks

tonik wrote:
There should be some commercial/noncomercial programs on the market, but
only with PL/SQL I would make a SELECT that returns INSERT statements.
Something like bellow:

SELECT 'INSERT INTO table_name (col1int,col2varchar,...)
VALUES ('||col1int||','''||col2varchar||''',...);'
FROM table_name;

Depends also on number of tables to be transported (should be crazy when
more than 10 ;-)).

Regards
Primz

You need to unload data into portable text file
Use spool in oracle tounload
If Oracle tables are large,then you can try fastreade
www.wisdomforce.co

fastreader willautomatically create data loader to DB