From: Pepe TD Vo <pepevo@yahoo.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
To: Pgsql-general <pgsql-general@postgresql.org>
To: PgAdmin Support List <pgadmin-support@lists.postgresql.org>
To: JC JC <shekharjchandra@hotmail.co.uk>
Subject: Re: migrate off oracle data to postgres
Date: Tue, 31 Mar 2020 15:51:35 +0000 (UTC)
Message-ID: <1493124385.1141236.1585669895986@mail.yahoo.com> (raw)
In-Reply-To: <DB6PR0902MB2216EE98F1DF8368DC95A331E5C80@DB6PR0902MB2216.eurprd09.prod.outlook.com>
References: <1587437647.1103378.1585664119295.ref@mail.yahoo.com>
<1587437647.1103378.1585664119295@mail.yahoo.com>
<DB6PR0902MB2216EE98F1DF8368DC95A331E5C80@DB6PR0902MB2216.eurprd09.prod.outlook.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 though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
On Tuesday, March 31, 2020, 11:46:58 AM EDT, JC JC <shekharjchandra@hotmail.co.uk> wrote:
#yiv3534479505 P {margin-top:0;margin-bottom:0;}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 remaining attributes based on the requirement.
Export to CSV is not required, as mentioned TYPE COPY will do a load of data if you like it to do Direct Data Streaming.As of my limited experience I never encountered any issue on the limit on data being transferred, but definitely the load time vary depending on the environment.
Regardsjc
From: Pepe TD Vo <pepevo@yahoo.com>
Sent: 31 March 2020 15:15
To: Pgsql-admin <pgsql-admin@postgresql.org>; Pgsql-general <pgsql-general@postgresql.org>; PgAdmin Support List <pgadmin-support@lists.postgresql.org>
Subject: migrate off oracle data to postgres 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 postgres? Ora2pg is limited data from oracle to postgresql right?
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 though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, pgsql-general@postgresql.org, pgadmin-support@lists.postgresql.org, shekharjchandra@hotmail.co.uk
Subject: Re: migrate off oracle data to postgres
In-Reply-To: <1493124385.1141236.1585669895986@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox