I have not tried this in a while but I think a SELECT with a "hint" will return
rows in the order of the index in the hint. This does NOT work for distributed
queries.
> On 09/12/2023 9:10 AM EDT Daniel Gustafsson wrote:
>
>
> > On 12 Sep 2023, at 14:26, Matthias Apitz wrote:
> >
> > El
> On 12 Sep 2023, at 14:26, Matthias Apitz wrote:
>
> El día martes, septiembre 12, 2023 a las 02:19:19 +0200, Peter J. Holzer
> escribió:
>
>>> - Or can we add additional parameters to the ora2pg.conf file to control
>>> this
>>> process and ensure that the data is imported sequentially, foll
El día martes, septiembre 12, 2023 a las 02:19:19 +0200, Peter J. Holzer
escribió:
> > - 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?
AFAIK,
On 2023-09-08 17:19:01 +0700, duc hiep ha wrote:
> 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
> 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
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 proces
