Re: Changing ROWID
Date: 5 Jan 1995 17:01:28 GMT
Message-ID: <3eh8l8$lbh_at_fred.uswnvg.com>
Barry Roomberg (barry.roomberg_at_compudata.com) wrote:
: -> Which ever way it does it, you could do your own research and find
: -> out: create a row look at its row id modify the row look at its row
: -> id again
: Too simple. What happens if you don't do "enough" to cause the
: threshhold condition that might cause the change. You are
: only proving that the "test" does not cause the effect, not
: that the effect won't ever happen.
I agree with that. I have actually experienced the "changing rowid"
phenomenon (once, about 1.5 years ago).
The table I worked with was BIG. It had about 6 million rows and a few
hundred megabytes in size (the size was obtained by calculating the
maximum size of a record with the number of records. It was probably about
20% larger than actual size but still in the hundreds of megabytes range).
In addition, it is probably affected by other database parameters. So, the
best bet is to ask ORACLE as they know how the engine works.
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!)
Kim Ng
Paradigm Computer Consulting, Inc.
20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012
U.S.A. Received on Thu Jan 05 1995 - 18:01:28 CET