Oracle-L: will the Return Order of rows change with time ?

From: Ratnesh Kumar Singh <ratnesh.singh_at_patni.com>
Date: Tue, 22 Oct 2002 02:38:40 -0800
Message-ID: <F001.004EF746.20021022023840@fatcity.com>

I have a very large DW table in which there are only inserts and NO updates/deletes.
The table grows by around 2-5 % every week due to new inserts.

I need to return the rows for each customer in the same order as inserted to table.
Due to design/delivery constraints , i cannot modify the table.

ques 1 : if i do a 'select * from table' with where clause but no order by clause,

will the Order of rows returned be the same whenever this query is executed ?

Is this gauranteed by Oracle ?

ques 2 : if i export/import this table , then execute the same query,

will the Order of rows returned be the same as before the export/import ?

ques 3 : if i use the 'move' cmd to rebuild this table , then execute my query,

will the Order of rows returned be the same as before the rebuild ?

any explanations are most welcome....

many thanks
ratnesh singh

Ratnesh Kumar Singh
Sr. Software Engineer
Patni Computer Systems Ltd
TTC Mahape , Navi Mumbai
Work : (91 22) 7611090/110/128/350 Ext. 2107/2106 Home : (91 22) 8662162
http://www.patni.com
World-Wide Partnerships. World-Class Solutions.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ratnesh Kumar Singh
INET: ratnesh.singh_at_patni.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 22 2002 - 05:38:40 CDT