Hello friends,
I want to migrate a large Oracle table to PostgreSQL, which is approximately 200GB in size and includes a LOB segment. This table has a primary key column named "ID," which increments by one unit (similar to a sequence). During the migration of this large table, sometimes the process terminates prematurely (due to network issues, etc.). As a result, I have to restart the import process either from the beginning or by using a WHERE clause in the ora2pg configuration file to import the remaining data from where it was previously terminated.
However, I've noticed that the import process in ora2pg doesn't seem to follow a consecutive order, starting from a small ID number and progressing to a larger ID number. Instead, it appears to import data randomly from various rows of the table. This makes it impossible to continue importing data from the point where it was terminated using a WHERE clause in ora2pg.
My questions are:
- Is it correct that ora2pg imports data from the Oracle table to the PostgreSQL table randomly and not sequentially from a smaller ID to a larger ID?
- Or can we add additional parameters to the ora2pg.conf file to control this process and ensure that the data is imported sequentially, following the primary key from smallest to largest?
Thank you,
Hans