migrate from PostgreSQL to Oracle

  • From: jo <jose.soares@xxxxxxxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Oct 2012 08:40:26 +0200

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



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


Other related posts: