Re: Post Oracle to Postgres migartion

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Post Oracle to Postgres migartion
Date: 2025-07-31 13:26:53
Message-ID: CANzqJaC+Ww5Jq4rYUJ8X5hO0B+2Wph6ay5Wjqjrhxn0_cXiX3A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jul 31, 2025 at 6:19 AM Raj <rajeshkumar(dot)dba09(at)gmail(dot)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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kamal Lekan AbdulWahab 2025-07-31 14:17:10 Re: Post Oracle to Postgres migartion
Previous Message Raj 2025-07-31 10:18:21 Post Oracle to Postgres migartion