When doing many select you should have the same order
but this is not guaranteed by Oracle.
The only official guaranty is to use an order by.
After an export/import or a move, you have the risk
that the rows will not be in the same order.
How big is the table ?
There is no unique id for the customer ?
- Ratnesh Kumar Singh <ratnesh.singh_at_patni.com> a
écrit : > Hi
>
> 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).
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.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 - 09:19:26 CDT