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
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? |