Re: Post Oracle to Postgres migartion

Create as little as possible before loading data. (The more indices there
are on a table, the longer it takes to insert a record; having FK
constraints means not only having to perform the check, but the records
might not exist in the referenced table, etc, etc)

On Mon, Aug 11, 2025 at 12:16 PM Raj <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:

> 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
>>>
>>>

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!