Sequence of objects to import - Ora2pg

From: Raj <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Sequence of objects to import - Ora2pg
Date: 2025-08-18 22:55:12
Message-ID: CAJk5Atb0Lbpwepa-Vm2v5Naav0-_fK8jjvTZMuXv+tcPfbc2qA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello All,

What's the sequence of objects to be imported while using Ora2pg v25
(oracle 18c to postgres 17.x) so that I don't get error and conflict
between parents and child tables etc.

Should I start with this order sequences, sequence_values,
Table,
Indexes
Views
Procedures, function, triggers and finally grants

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-08-19 13:53:46 PgBackrest directory access from another server
Previous Message msalais 2025-08-18 21:21:46 RE: Clearing of temp files is very slow in pg16