Re: Best practice to load a huge table from ORACLE to PG

Someone mentioned FastReader. Here the pdf "Best Practices for high-
speed data transfer from Oracle to Netezza using FastReader (relevant
for PostgreSQL as well)": 
http://www.wisdomforce.com/dweb/resources/docs/Or=
acleToNetezzaWithFastReader.pdf
There are few limitations in PG loader that you would need to overcome


On Apr 26, 6:25 am, malo...@[EMAIL PROTECTED]
 ("Adonias Malosso") wrote:
> Hi All,
>
> I=B4d like to know what=B4s the best practice to LOAD a 70 milion rows,
10=
1
> 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