Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 532682E0070 for ; Sat, 26 Apr 2008 12:33:15 -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 84002-01 for ; Sat, 26 Apr 2008 12:33:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id 87BBD2E0069 for ; Sat, 26 Apr 2008 12:33:11 -0300 (ADT) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m3QFXloV016889 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 26 Apr 2008 08:33:50 -0700 Message-ID: <48134B38.4050807@commandprompt.com> Date: Sat, 26 Apr 2008 08:33:12 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: spotluri@ismartpanache.com CC: Adonias Malosso , pgsql-performance@postgresql.org Subject: Re: Best practice to load a huge table from ORACLE to PG References: <9603.1209223048@ismartpanache.com> In-Reply-To: <9603.1209223048@ismartpanache.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Sat, 26 Apr 2008 08:33:51 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/374 X-Sequence-Number: 29867 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)