Re: PostgreSQL to Oracle - Mailing list pgsql-general
From | Martin Gainty |
---|---|
Subject | Re: PostgreSQL to Oracle |
Date | |
Msg-id | BAY133-DAV55245A0DD6C98B88BE8D6AE780@phx.gbl Whole thread Raw |
In response to | PostgreSQL to Oracle ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>) |
List | pgsql-general |
Ezequias-
first you will need to pg_dump everything.. schema..tables..functions then your Data into a text format which has no whitespace characters
first you will need to pg_dump everything.. schema..tables..functions then your Data into a text format which has no whitespace characters
There are 2 bulk loaders available from Oracle
1)Brand new DataPump
2)Tried and true sqlldr (which I recommend)
I would highly recommend reading and understanding the Extract / Transform /Load document located at
http://www.oracle.com/technology/obe/obe10gdb/bidw/etl2/etl2.htm
Also triple check the extents you are allocating for the tablespace for tables to be inserted into that tablespace will guaranteed to be sufficient size
(If you dont know the size of a block ask..as this isnt something you can fix later..unless you want to spend a 3day weekend doing a rollback..)
Become familiar with LOAD DATA INFILE command links available from either Stanford (or Oracle)
1)Brand new DataPump
2)Tried and true sqlldr (which I recommend)
I would highly recommend reading and understanding the Extract / Transform /Load document located at
http://www.oracle.com/technology/obe/obe10gdb/bidw/etl2/etl2.htm
Also triple check the extents you are allocating for the tablespace for tables to be inserted into that tablespace will guaranteed to be sufficient size
(If you dont know the size of a block ask..as this isnt something you can fix later..unless you want to spend a 3day weekend doing a rollback..)
Become familiar with LOAD DATA INFILE command links available from either Stanford (or Oracle)
Be mindful that Oracle DB is used by ALL of the major players
so inserting nulls which could violate any constraint (constraints being unique or foreign key) are forbidden
In fact inserting nulls into any column is discouraged as it may violate the relationship of dependent table records to primary table
so inserting nulls which could violate any constraint (constraints being unique or foreign key) are forbidden
In fact inserting nulls into any column is discouraged as it may violate the relationship of dependent table records to primary table
If you have time and or diskspace constraint you may want to look at Direct Path Loading which creates preformatted data blocks
http://download-west.oracle.com/docs/cd/B10501_01/server920/a96524/c21dlins.htm
http://download-west.oracle.com/docs/cd/B10501_01/server920/a96524/c21dlins.htm
Caveat emptor with this option as the logger is turned off and if there are any burps along the way you wont know which record it burped on
Feel free to ping me if you have any questions/
Saludos Cordiales,
Martin --
---------------------------------------------------------------------------
This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary , confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited.
---------------------------------------------------------------------------
Le présent message électronique (y compris les pièces qui y sont annexées, le cas échéant) s'adresse au destinataire indiqué et peut contenir des renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le destinataire de ce document, nous vous signalons qu'il est strictement interdit de le diffuser, de le distribuer ou de le reproduire.
This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary , confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited.
---------------------------------------------------------------------------
Le présent message électronique (y compris les pièces qui y sont annexées, le cas échéant) s'adresse au destinataire indiqué et peut contenir des renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le destinataire de ce document, nous vous signalons qu'il est strictement interdit de le diffuser, de le distribuer ou de le reproduire.
----- Original Message -----To: pgsql general ; PostgreSQLSent: Friday, March 09, 2007 12:54 PMSubject: [GENERAL] PostgreSQL to OracleHi list,
Is it a simple action to convert a database from PostgreSQL to Oracle ?
I mean a simple database with
33 tables
8 functions
31 sequencies
2 triggers
1 type
3 views
Has someone any idea ?
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspotcom/
use Mozilla Firefox:http://br.mozdev.org/firefox/
pgsql-general by date: