Home » RDBMS Server » Server Utilities » SQL Loader: Sort the datafile
SQL Loader: Sort the datafile [message #304692] Thu, 06 March 2008 03:36 Go to next message
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member
Is it somehow possible to sort the datafile coming in via SQL Loader. For example, we have fixed length data coming in and we know that columns 2 thru 10 is numeric data. Can we get the datafile sorted on these positions somehow before the load.
Re: SQL Loader: Sort the datafile [message #304696 is a reply to message #304692] Thu, 06 March 2008 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The real question is why?
Tables are set, sets don't have order, why do you want an order?

Re: SQL Loader: Sort the datafile [message #304700 is a reply to message #304692] Thu, 06 March 2008 04:57 Go to previous message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Even though you'd load a sorted file (doesn't matter how you'd do that (sorting, I mean)), it does NOT mean that "SELECT * FROM this_table" will return result which will be ordered by anything. If you want to fetch records ordered by something, you MUST use the ORDER BY clause in the SELECT statement.
Previous Topic: Bad files when using multiple input files with sqlldr
Next Topic: Export and Import data
Goto Forum:

Current Time: Sun Oct 23 13:02:13 CDT 2016

Total time taken to generate the page: 0.15895 seconds