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: 65144
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: 21148
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: Problem while importing Arabic characters
Goto Forum:

Current Time: Sat Aug 19 21:21:07 CDT 2017

Total time taken to generate the page: 0.21179 seconds