public inbox for [email protected]  
help / color / mirror / Atom feed
From: Raj <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Sequence of objects to import - Ora2pg
Date: Tue, 19 Aug 2025 04:25:12 +0530
Message-ID: <CAJk5Atb0Lbpwepa-Vm2v5Naav0-_fK8jjvTZMuXv+tcPfbc2qA@mail.gmail.com> (raw)

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


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Sequence of objects to import - Ora2pg
  In-Reply-To: <CAJk5Atb0Lbpwepa-Vm2v5Naav0-_fK8jjvTZMuXv+tcPfbc2qA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox