.
From: Pepe TD Vo
Sent: 31 March 2020 17:45
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
; JC JC
Subject: Re: migrate off oracle data to postgres
@JC - I do have ora2pg set up last year in test environment already and that
what I suggested team using insert
ersjc
From: Pepe TD Vo
Sent: 31 March 2020 16:51
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
; JC JC
Subject: Re: migrate off oracle data to postgres I have tables ddl data
definitions already. Only need to move the data over off Oracle to Postgres
Bach-Nga
No one in this world is pur
From: Pepe TD Vo
Sent: 31 March 2020 16:51
To: Pgsql-admin ; Pgsql-general
; PgAdmin Support List
; JC JC
Subject: Re: migrate off oracle data to postgres
I have tables ddl data definitions already. Only need to move the data over
off Oracle to Postgres
Bach-Nga
No one in this world
FDW for oracle and ora2pg both are too slow compared to offload data in a file
and load into PostgreSQL. When I was doing one of my migrations I found the
best solution was to download data using sqlldr on to the database host where
PostgreSQL instance is running and load it using COPY command.
On 3/31/20 8:51 AM, Pepe TD Vo wrote:
I have tables ddl data definitions already. Only need to move the data
over off Oracle to Postgres
PostgreSQL Foreign Data Wrapper for Oracle:
http://laurenz.github.io/oracle_fdw/
--
Adrian Klaver
adrian.kla...@aklaver.com
I have tables ddl data definitions already. Only need to move the data over
off Oracle to Postgres
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their
mistakes you will be alone. So judge less, love and forgive more.To call him a
dog hardly seems to do him justice
In my view ora2pg can do most of the stuff you requested.
ora2pg can be used to generate the DDL from oracle to postgres based on
attributes set in ora2pg conf file (for example TYPE TABLE, will allow getting
oracle DDL in an output file, TYPE COPY will bring the data). No doubt you need
to set
You should explore EnterprisDB’s Migration ToolKit (MTK).
Regards
John Wiencek
> On Mar 31, 2020, at 9:15 AM, Pepe TD Vo wrote:
>
> Hello,
>
> I have a huge data on Oracle, would you please suggest how to migrate all
> data off Oracle to Postgres? Do I need to export into csv and upload to
