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

From Kamal Lekan AbdulWahab
Subject Re: Post Oracle to Postgres migartion
Date
Msg-id CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com
Whole thread Raw
In response to Post Oracle to Postgres migartion  (Raj <rajeshkumar.dba09@gmail.com>)
Responses Re: Post Oracle to Postgres migartion
List 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.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

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Post Oracle to Postgres migartion
Next
From: "DINESH NAIR"
Date:
Subject: Re: Post Oracle to Postgres migartion