Re: Post Oracle to Postgres migartion

From: Kamal Lekan AbdulWahab <dba(dot)abdulwahab(at)gmail(dot)com>
To: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Post Oracle to Postgres migartion
Date: 2025-07-31 14:17:10
Message-ID: CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You can look at SEQUENCES if they are out of sync with values in Oracle.
Sometimes, they also affect auto-increment columns. Have you checked and
recreated all users accounts? Passwords do not copy over automatically.

On Thu, Jul 31, 2025 at 3: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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message DINESH NAIR 2025-07-31 19:37:23 Re: Post Oracle to Postgres migartion
Previous Message Ron Johnson 2025-07-31 13:26:53 Re: Post Oracle to Postgres migartion