sorting and loading a table

[naushi]

If I wanted to sort my table data in primary-key sequence to load into an Oracle table, how do I do this ?
Is there a sort utility available Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[carp]

Well, you can sort it before loading it, but the question is "what will this buy for you"?
Oracle does not guarantee that your data will be physically stored in the same order you load it.

 

[Dagon]

The only benefit might be that you could create your indexes with the nosort option. However, if you're having to sort the data beforehand, there probably isn't much advantage over letting Oracle do the sort.

There is no external sort utility in Oracle, so you would probably have to use an operating system command like UNIX sort.