SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does SQL Loader load data in chronological order ?

2652054Jun 22 2020 — edited Jun 22 2020

Hi Experts,

I have a requirement where i have to load data from files into Oracle table coming in from various sources. The format of the file remains same from all sources. The data in the file is in chronological order. However no seq_no is defined in the file itself. So just wanted to check if

the sequence/chronological order of the rows is maintained when loading the data from sqlloader to the oracle database , or is there a possibility that the chronological order of the rows in the file and rows in the database would get mixed up ? If yes, then what would be best approach to go about this requirement .

I checked this link but it did not give a clear picture of what i was looking for

https://docs.oracle.com/cd/B10501_01/text.920/a96518/aload.htm

Any help is much appreciated.

Regards,

Praveen

This post has been answered by odie_63 on Jun 22 2020

Jump to Answer

Added on Jun 22 2020

6 comments

1,125 views