Index is unusable after using Direct path of SQL Loader
When using the Direct path of SQL Loader to load records from a comma(,) seperated file into a table, the index which I specify the records are sorted in becomes unusable. In the log file created by SQL Loader the error: "ORA-01409: NOSORT option may not be used; rows are not in ascending order" occurs. I am pre sorting the data in the order of the index, the index is a multi column index. The index and table prior to initiating SQL Loader are not empty and contain existing records.
Can anybody suggest a reason as to why this is happening even thought I am pre sorting the data in ascending order as per the index?
Brad.