Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5ABA12E0032 for ; Sat, 26 Apr 2008 12:17:36 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80486-05 for ; Sat, 26 Apr 2008 12:17:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from app04.sm.onr.chicago.hostway (fw.mfg.onr.siteprotect.com [64.26.60.152]) by developer.postgresql.org (Postfix) with ESMTP id 973FE2E0031 for ; Sat, 26 Apr 2008 12:17:30 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by app04.sm.onr.chicago.hostway (Postfix) with ESMTP id C3C7D4000B7; Sat, 26 Apr 2008 10:17:28 -0500 (CDT) MIME-Version: 1.0 X-Mailer: AtMail PHP 5.2 Message-ID: <9603.1209223048@ismartpanache.com> To: Adonias Malosso , "Joshua D. Drake" Reply-To: spotluri@ismartpanache.com Content-Type: multipart/alternative; boundary="=_7f48dfc2a1e903179e9bab23363726f3" X-Origin: 121.97.28.3 Date: Sat, 26 Apr 2008 10:17:28 -0500 Subject: Re: Best practice to load a huge table from ORACLE to PG From: Potluri Srikanth Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.837 tagged_above=0 required=5 tests=AWL=0.836, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200804/373 X-Sequence-Number: 29866 --=_7f48dfc2a1e903179e9bab23363726f3 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" But do we link oracle trigger to postgres trigger ? i mean : oracle trigger will take a note of what has been changed . but then how do we pass those changes to postgres trigger ? can u suggest any logic or algorithm ? Regards,=20 Srikanth k Potluri=20 +63 9177444783(philippines)=20 On Sat 26/04/08 8:40 PM , "Joshua D. Drake" jd@commandprompt.com sent: Adonias Malosso wrote:=20 > Hi All,=20 > =20 > I=EF=BF=BDd like to know what=EF=BF=BDs the best practice to LOAD a 70 m= ilion rows, 101 =20 > columns table=20 > from ORACLE to PGSQL.=20 > =20 > The current approach is to dump the data in CSV and than COPY it to =20 > Postgresql.=20 > =20 > Anyone has a better idea.=20 Write a java trigger in Oracle that notes when a row has been =20 added/delete/updated and does the exact same thing in postgresql.=20 Joshua D. Drake=20 > =20 > =20 > Regards=20 > Adonias Malosso=20 -- =20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org [1])=20 To make changes to your subscription:=20 http://www.postgresql.org/mailpref/pgsql-performance=20 Links: ------ [1] http://sitemail7.hostway.com/javascript:top.opencompose(\'pgsql-performance= @postgresql.org\',\'\',\'\',\'\') --=_7f48dfc2a1e903179e9bab23363726f3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8" But do we link oracle trigger to postgres trigger ?

i mean :

oracle trigger will take a note of what has been changed .
but then how do we pass those changes to postgres trigger ?

can u suggest any logic or algorithm ?

Regards,
Srikanth k Potluri
+63 9177444783(philippines)

On Sat 26/04/08 8:40 PM , "Joshua D. Dr= ake" jd@commandprompt.com sent:

Ad= onias Malosso wrote:
> Hi All,
>=20
> I=EF=BF=BDd like to know what=EF=BF=BDs th= e best practice to LOAD a 70 milion rows, 101=20
> columns table
> from ORACLE to PGSQL.
>=20
> The current approach is to dump the data i= n CSV and than COPY it to=20
> Postgresql.
>=20
> Anyone has a better idea.

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

Joshua D. Drake

>=20
>=20
> Regards
> Adonias Malosso

--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgre= sql.org)
To make changes to your subscription:
http://w= ww.postgresql.org/mailpref/pgsql-performance

--=_7f48dfc2a1e903179e9bab23363726f3--