Thanks Peter... --- On Tue, 2/10/09, Peter Eisentraut <pete...@gmx.net> wrote: From: Peter Eisentraut <pete...@gmx.net> Subject: Re: [GENERAL] ora2pg or dbi_link ? To: sharmi...@yahoo.com Cc: "General postgres mailing list" <pgsql-general@postgresql.org> Date: Tuesday, February 10, 2009, 1:46 AM
SHARMILA JOTHIRAJAH wrote: > Ive been struggling to query some of my oracle tables from postgres using the dbi_link and its not working. > Have anyone tried ora2pg for querying the oracle database from postgres? ora2pg is not really made for that. It is for a one-time conversion. So for one-time conversion which is faster dbi_link or ora2pg? Sharmila