Unload data

[tonik]

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

[=?ISO-8859-2?Q?Primo=BE_Govekar?=]

Re: Unload data

tonik wrote:

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,col2va rchar,...)
VALUES ('||col1int||', '''||col2varcha r||''',...);'
FROM table_name;

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

Regards
Primz

[dbaman]

Oracle data unload into DB2

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

https://www.wisdomforce.co

fastreader willautomatical ly create data loader to DB