MIME-Version: 1.0
References: 
 <CAJk5Atb+2r430wJqONZLLYvR0ZWcQ8qPc1uuoqZGao_O2wLrrA@mail.gmail.com>
In-Reply-To: 
 <CAJk5Atb+2r430wJqONZLLYvR0ZWcQ8qPc1uuoqZGao_O2wLrrA@mail.gmail.com>
From: Kamal Lekan AbdulWahab <dba.abdulwahab@gmail.com>
Date: Thu, 31 Jul 2025 07:17:10 -0700
Message-ID: 
 <CA+B9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ@mail.gmail.com>
Subject: Re: Post Oracle to Postgres migartion
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000af3d89063b3a4c36"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BB9d-fWbhRRYaYvQXrT1Jdy9MrDS2qdbSRghdwJR9M9DBkbnQ%40mail.gmail.com>
Precedence: bulk

--000000000000af3d89063b3a4c36
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFAM Raj <rajeshkumar.dba09@gmail.com> w=
rote:

> Hi All,
>
> Post Oracle to Postgres Migration using Ora2pg, as a dba what activites w=
e
> may have to perform apart from checking count of objects, rows, vacuum
> analyze etc
>

--000000000000af3d89063b3a4c36
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">You can look at SEQUENCES if they are out of sync with val=
ues in Oracle. Sometimes, they also affect auto-increment columns. Have you=
 checked and recreated all users accounts? Passwords do not copy over autom=
atically.</div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">On Thu, Jul 31, 2025 at 3:19=E2=80=AFAM Raj =
&lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x"><div dir=3D"auto">Hi All,<div dir=3D"auto"><br></div><div dir=3D"auto">P=
ost Oracle to Postgres Migration using Ora2pg, as a dba what activites we m=
ay have to perform apart from checking count of objects, rows, vacuum analy=
ze etc</div></div>
</blockquote></div>

--000000000000af3d89063b3a4c36--