Re: Post Oracle to Postgres migartion - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Post Oracle to Postgres migartion
Date
Msg-id CANzqJaC+Ww5Jq4rYUJ8X5hO0B+2Wph6ay5Wjqjrhxn0_cXiX3A@mail.gmail.com
Whole thread Raw
In response to Post Oracle to Postgres migartion  (Raj <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
On Thu, Jul 31, 2025 at 6:19 AM Raj <rajeshkumar.dba09@gmail.com> wrote:
Hi All,

Post Oracle to Postgres Migration using Ora2pg, as a dba what activites we may have to perform apart from checking count of objects, rows, vacuum analyze etc

That "etc" is everything except what you didn't explicitly list. 😉

Did you create all the same indices and triggers?
Did you convert all NUMERIC and NUMERIC(38,0) to BIGINT in Ora2pg?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Post Oracle to Postgres migartion
Next
From: Kamal Lekan AbdulWahab
Date:
Subject: Re: Post Oracle to Postgres migartion