Request a Demo
Home   >   mailing lists

Sequence of objects to import - Ora2pg - Mailing list pgsql-admin

From Raj
Subject Sequence of objects to import - Ora2pg
Date
Msg-id CAJk5Atb0Lbpwepa-Vm2v5Naav0-_fK8jjvTZMuXv+tcPfbc2qA@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
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




pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Clearing of temp files is very slow in pg16
Next
From: Ron Johnson
Date:
Subject: PgBackrest directory access from another server