RE: migrate from PostgreSQL to Oracle
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Oct 2012 15:42:46 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
