Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle data to PG - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: Oracle data to PG
Date
Msg-id 2097661791.3351141.1659014966420@mail.yahoo.com
Whole thread Raw
In response to Re: Oracle data to PG  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
List pgsql-admin
Tree view
As Anyon said.
I use SQL Developer dump into csv and import to Postgres plsql or pgadmin.



On Thu, Jul 28, 2022 at 8:19, Juan José Santamaría Flecha
<juanjo.santamaria@gmail.com> wrote:

On Thu, Jul 28, 2022 at 10:56 AM Dischner, Anton <Anton.Dischner@med.uni-muenchen.de> wrote:

 

we are searching for a way to import a dump from an Oracle Installation into PostgreSQL.

 

Ist not administrated by us, so foreing table or connect as an user (as ora2pg seems to need) is not an option.

 

Why don't you have the Oracle people dump the data you need into a CSV file and COPY it into Postgres?

Regards,

Juan José Santamaría Flecha

pgsql-admin by date:

Previous
From: "Pierson Patricia L (Contractor)"
Date:
Subject: RE: [EXT] Re: Oracle data to PG
Next
From: Scott Ribe
Date:
Subject: Re: Oracle data to PG