Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rowid question
Thomas, is that true even if the row has to be migrated to a different block
when it gets expanded later?
Thomas Kyte wrote in message <360bded1.106307201_at_192.86.155.100>...
>A copy of this was sent to mtillberg_at_my-dejanews.com
>(if that email address didn't require changing)
>On Thu, 03 Sep 1998 17:27:02 GMT, you wrote:
>
>> Are rowid values guaranteed to be consistant over updates if the rows
they
>>point to aren't changed? For instance, I have a table that users can
access
>>in an editor. Although I don't care in what order the data is sorted
>>(actually, I don't want it sorted by value), I want the data to show up in
>>the same sequence everytime. Also, the users only access a few rows at a
>>time. Here's the situation:
>>
>>User1 loads data into the editor.
>>User2 loads data into the editor.
>>User2 makes changes and commits.
>>User1 makes changes and commits.
>
>yes, once a row is inserted -- its rowid is *never* changed.
>
>>
>> I want to make sure that user1's data has the same rowids as when he
>>started.
>>
>>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>--
>http://govt.us.oracle.com/ -- downloadable utilities
>
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
Received on Thu Sep 03 1998 - 14:56:58 CDT