Re: Order of rows after sqlload

If the order of the loaded rows is crucial, you can add a column to your table which holds a record number. Then tell SQL*Loader to load RECNUM or SEQUENCE into that column. RECNUM will insert the logical record number from the data file while SEQUENCE will load a unique increasing sequential number (in case you are appending several data files into one table). See the SQL*Loader doc in Oracle7 Server Utility User's Guide - look for the section called Generating Data.

-- 
Monique M Morris
Sr Oracle Applications Developer
Childrens Hospital Los Angeles