Обсуждение: ora2pg or dbi_link ?

Поиск
Список
Период
Сортировка

ora2pg or dbi_link ?

От
SHARMILA JOTHIRAJAH
Дата:
Hi,
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? If so whats your feedback on that?
Thanks
Sharmila

Re: ora2pg or dbi_link ?

От
Peter Eisentraut
Дата:
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.

Re: ora2pg or dbi_link ?

От
SHARMILA JOTHIRAJAH
Дата:

Thanks Peter...
--- On Tue, 2/10/09, Peter Eisentraut <peter_e@gmx.net> wrote:
From: Peter Eisentraut <peter_e@gmx.net>
Subject: Re: [GENERAL] ora2pg or dbi_link ?
To: sharmi_jo@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 orora2pg?
Sharmila