.
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
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
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