There are couple of options.
I would start from https://ora2pg.darold.net/start.html
HTH
Karth
Sent from Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Shravan Kumar Kota <shravankota@xxxxxxxxx>
Sent: Friday, April 14, 2023 1:40:04 AM
To: gogala.mladen@xxxxxxxxx <gogala.mladen@xxxxxxxxx>
Cc: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Oracle DB migration to Postgrsql
Any one can help me on this please .
On Thu, Apr 13, 2023, 08:22 Shravan Kumar Kota
<shravankota@xxxxxxxxx<mailto:shravankota@xxxxxxxxx>> wrote:
Hello Mladen,
Thanks you for your reply.
I didn't understand what you are saying.
You mean to say that we need to take help from developer while migrating
database ?
Thanks.
Shravan.
On Thu, Apr 13, 2023, 07:49 Mladen Gogala
<gogala.mladen@xxxxxxxxx<mailto:gogala.mladen@xxxxxxxxx>> wrote:
On 4/12/23 10:08, Shravan Kumar Kota wrote:
Hi all ,
Is any one done migration of Oracle database to Postgrsql?
Yes
If yes please let me know process / steps to do it or if any doc or url please
share with me.
Thanks
Shravan.
LOL! The above message exudes a rare degree of self-confidence! The knowledge
you refer to is something that I sell. However, even if if you somehow got my
part of knowledge, you would still need the developer's side of the story. The
developers were in charge of the application. I was only helping them with both
databases. Remember: as a DBA you are a SME for everything database. The trick
is in learning both.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com