Re: Order of rows after sqlload

I don't really care about the order, I was just curious. This is a data warehouse, so there are no deletes. The table is truncated prior to the load.

thanks,

...gary

Steve Butler <sbut-is_at_seatimes.com> wrote:

>On Tue, 27 Feb 1996, Gary Nilges wrote:
>> If I load an empty table from a flat file using sqlload the rows don't
>> wind up in the same order in the table that they were in the flat
>> file. Does Oracle order by index or key or somthing?
 

>There is no implied ordering of data by Oracle. If the table were newly
>created then the order after loading would likely be the same as the flat
>file (not guaranteed but usually so).
 

>However, a table that has seen some activity followed by a delete
>tablename; will be filled according to the order of the rows on the free
>list chain (which might be the reverse order of how they were deleted).
 

>Not sure what would happen on a truncate table tablename. I think that
>is supposed to reset the free list.
 

>However, why are you bothered by the ordering? A relational database
>isn't supposed to depend or care about the ordering of records in the
>file (I know certain retrieval performance might suffer but....)
 

>+----------------------------------------------------+
>| Steve Butler Voice: 206-464-2998 |
>| The Seattle Times Fax: 206-382-8898 |
>| PO Box 70 Internet: sbut-is_at_seatimes.com |
>| Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA |
>+----------------------------------------------------+
>All standard and non-standard disclaimers apply.
>All other sources are annonymous.
Received on Wed Feb 28 1996 - 00:00:00 CET