Re: Post Oracle to Postgres migartion

When using Ora2pg after taking dump of objects...while restoring which
objects should I start first and can somebody help me with list of sequence
of objects to be restored?

On Fri, 1 Aug 2025, 02:48 Raj, <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:

> Thank you All. In my env, darold himself is already doing migration, I
> just wanted to be ready with post migration steps .
>
> On Fri, 1 Aug 2025, 01:07 DINESH NAIR, <Dinesh_Nair(at)iitmpravartak(dot)net>
> wrote:
>
>> Hi ,
>>
>>
>>
>> >> 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?
>>
>> Best practice followed for migration :
>>
>>
>> 1. First perform table data migration. Row count verification between
>> source and target tables. Random data checks between source and target at
>> row level.
>> 2. Applying primary key, constraints and indexes
>> 3. Applying triggers
>> 4. Then sequences migration
>> 5. Database configuration: configuration of postgres.config ,
>> shared_buffers, max_connections, configuring maintenace jobs
>> 6. Setting user roles and permissions
>>
>>
>>
>>
>> Regards
>>
>> Dinesh Nair
>>
>>
>> ------------------------------
>> *From:* Kamal Lekan AbdulWahab <dba(dot)abdulwahab(at)gmail(dot)com>
>> *Sent:* Thursday, July 31, 2025 7:47 PM
>> *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
>>
>> You don't often get email from dba(dot)abdulwahab(at)gmail(dot)com(dot) Learn why this
>> is important <https://aka.ms/LearnAboutSenderIdentification>
>> Caution: This email was sent from an external source. Please verify the
>> sender’s identity before clicking links or opening attachments.
>> 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
>>
>>