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

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

Potluri Srikanth wrote:
> 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 ?

I am assuming you can use the java trigger from oracle to load the
postgresql jdbc driver, make a connection to postgresql and perform
whatever statement needed to be done.

Sincerely,

Joshua D. Drake

P.S. It is possible that Oracle can't do this (I don't know)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2008-04-26 16:13:34 Re: Best practice to load a huge table from ORACLE to PG
Previous Message Potluri Srikanth 2008-04-26 15:17:28 Re: Best practice to load a huge table from ORACLE to PG