Migrating data from Oracle 9i to PostgreSQL

<krokodylek@xxxxxxxxx> · Tue, 4 Apr 2006 14:01:30 CEST

Hi :-)

I sure hope I'm asking in the right place...

Is there any automated or semi-automated way of migrating data from Oracle
database (9.2.0.4) to PostgreSQL one?

I only need the data, nothing else (not stored procedures, indexes, etc.), the
relations are pretty simple, for example:

CREATE TABLE EMAIL
(
  UNID             VARCHAR2(32 BYTE)            NOT NULL,
  SUBJECT          VARCHAR2(4000 BYTE),
  SEND_FROM        VARCHAR2(255 BYTE),
  PRODUCT_CASE_ID  VARCHAR2(32 BYTE),
  RECEIVE_DATE     DATE,
  SEND_TO          VARCHAR2(255 BYTE),
  SUBMITED_BY      VARCHAR2(255 BYTE),
  COPY_TO          VARCHAR2(255 BYTE),
  SEND_BY          VARCHAR2(255 BYTE),
  PUB              INTEGER                      DEFAULT 0                    
NOT NULL,
  CONTENT          CLOB                         DEFAULT empty_clob(),
  RECIPIENT        VARCHAR2(255 BYTE)
)

I will be very grateful for any suggestions.

Best regards,
Maciej Zieba