View Single Post

   
  #1 (permalink)  
Old 04-29-2008, 08:32 PM
Adonias Malosso
 
Posts: n/a
Default Best practice to load a huge table from ORACLE to PG

Hi All,

I´d like to know what´s 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

Reply With Quote