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