Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: When does ROWID change ?
In article <8392p9$mdd$1_at_nnrp1.deja.com>, jdefreitas_at_my-deja.com writes
>So, does this mean in a scenario where records are constantly being
>written to a table, and a batch process records the ROWID of the last
>row inserted in the table, I can tell which records were written before
>this time or after this time by comparing ROWIDs in a "less than"
>or "greater than" logical comparison?
>
Hi,
Personally I would never use any kind of mechanism like this.
If you need this kind of info then create and maintain it yourself
(or via triggers if its an app).
Even if, by a miracle, the logical range comparisons worked then, who's
to say that some rows had not been deleted since your last load and
oracle then reuses those blocks, this may break the assumptions on rowid
'sequencing'.
If I had this presented to me in a design I'd errr.. suggest a rethink.
Steve Haynes
Received on Tue Dec 28 1999 - 20:32:08 CST
![]() |
![]() |