Migrating data from Oracle 9i to PostgreSQL

From: <krokodylek(at)tenbit(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Migrating data from Oracle 9i to PostgreSQL
Date: 2006-04-04 13:36:13
Message-ID: E1FQjpV-0005ZU-00@ap-04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Browse pgsql-general by date

  From Date Subject
Next Message patrick 2006-04-04 13:40:49 Re: recover from base directory?
Previous Message Tom Lane 2006-04-04 13:31:02 Re: recover from base directory?