Extract data from DB2 to Oracle

chrisinchrist · #1 (**permalink**) 11-25-11, 01:33

Hi guys,

I need to connect a DB2 server outside my firm to extract the data and import to my Oracle DB. This action has to be taken periodically. Efficient performance is necessary. How could I do that? I tried to use Access 2007 with ODBC to connect the DB2 and import to my Oracle DB (using ODBC). It worked but the performance is unacceptable. It took 40 minutes to extract the data from a view with 5 columns with 100,000 data amount. Any better suggestions? Please help. Thanks a lot!!.

Cheers,
Chris

przytula_guy · #2 (**permalink**) 11-25-11, 01:53

try to use the export command in command line..
see with explain if the access-path to data is as expected..

Internet Services

Web Development

Digital Marketing

Consumer Tech