Best practice to load a huge table from ORACLE to PG

------=_Part_697_29964152.1209216322651
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,

I=B4d like to know what=B4s the best practice to LOAD a 70 milion rows,
101
columns table
from ORACLE to PGSQL.

The current approach is to dump the data in CSV and than COPY it to
Postgresql.

Anyone has a better idea.


Regards
Adonias Malosso

------=_Part_697_29964152.1209216322651
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi All,<br><br>I=B4d like to know what=B4s the best practice to LOAD a 70
m=
ilion rows, 101 columns table <br>from ORACLE to PGSQL. <br><br>The
current=
 approach is to dump the data in CSV and than COPY it to
Postgresql.<br><br=
>
Anyone has a better idea.<br><br><br>Regards<br>Adonias Malosso<br>

------=_Part_697_29964152.1209216322651--