Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sorting and loading a table

Status
Not open for further replies.
naushi

naushi

ISP
Jan 18, 2002
89
US
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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
704
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
595
carp
carp
TheLazyPig
  • Question
Button not aligned after click
Replies
0
Views
72
TheLazyPig
TheLazyPig
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
634
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
760
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top