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

by jd@[EMAIL PROTECTED] ("Joshua D. Drake") Apr 26, 2008 at 08:10 AM

Adonias Malosso wrote:
> 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.

Write a java trigger in Oracle that notes when a row has been 
added/delete/updated and does the exact same thing in postgresql.

Joshua D. Drake


> 
> 
> Regards
> Adonias Malosso


-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

10 Posts in Topic:

Best practice to load a huge table from ORACLE to PG

malosso@[EMAIL PROTECTED]

2008-04-26 10:25:22

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

jd@[EMAIL PROTECTED] (&q

2008-04-26 08:10:24

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

llonergan@[EMAIL PROTECTE

2008-04-26 09:13:34

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

jonah.harris@[EMAIL PROTE