RE: migrate from PostgreSQL to Oracle

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Wed, 24 Oct 2012 15:42:46 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD112159331_at_G5W2734.americas.hpqcorp.net>

The sqlldr utility can be used to load delimited or fixed column position text data into Oracle tables.

You may want to reference Oracle support note: 393760.1 How To Migrate Non-Oracle Databases For Which A Migration Workbench Option Is Not Available

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jo Sent: Wednesday, October 24, 2012 2:40 AM To: ORACLE-L
Subject: migrate from PostgreSQL to Oracle

Hi all,

I'm looking for some linux script to migrate from pg to oracle. At the moment I dump data from pg using pg_dump in the format: INSERT INTO table (columns) (values)
then I load it into the Oracle db using cx_Oracle this procedure is so slow, and sometimes I have to edit and modify data manually because some INSERT format aren't compatible. Is there any interesting linux script to do this more easily?

thanks
j

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 24 2012 - 17:42:46 CEST