Re: Order of rows after sqlload
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1996/02/28
Message-ID: <Pine.SUN.3.91.960228083314.4665C-100000_at_seatimes>#1/1
Date: 1996/02/28
Message-ID: <Pine.SUN.3.91.960228083314.4665C-100000_at_seatimes>#1/1
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?
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