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 14:01:30
Message-ID: E1FQkDy-0005fn-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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2006-04-04 14:39:07 Re: Self-referencing and inherited table
Previous Message Tom Lane 2006-04-04 13:52:52 Re: recover from base directory?