Unload data

tonik wrote:

Quote: I want to unload data from table in oracle to table in another database,for example DB2. > Can you help me with a sample code? thanks! >

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