Ordering of records on load

From: Cathy Cantieri <nojunk_at_nowhere.edu>
Date: 12 May 1999 17:39:32 GMT
Message-ID: <01be9c9d$c55c1f60$f68f6d81@212833>

When loading records into a table using SQL*Loader can you guaranty that the records will query out in the same order that they are in the datafile by truncating the table before the load? The table being loaded doesn't have any indexes or constraints on it. I have tested it several times and it has worked but before I put it in production I need to make sure that it will continue to work. I have to be able to get the data records and process them in the exact order that they were in the datafile.

Cathy Cantieri
mailto:cathy.cantieri_at_utmb.edu Received on Wed May 12 1999 - 12:39:32 CDT