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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Adonias Malosso <malosso(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Best practice to load a huge table from ORACLE to PG
Date: 2008-04-26 15:10:24
Message-ID: 481345E0.5050900@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Potluri Srikanth 2008-04-26 15:17:28 Re: Best practice to load a huge table from ORACLE to PG
Previous Message Thomas Spreng 2008-04-26 14:12:39 Re: Oddly slow queries