tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>
>Wait a minute, a rowid for a row will *never* repeat *never* change.
>
>If you delete a row and reinsert it, as far as anyone is concerned it
>is simply NOT the same row.
>
>A rowid for a row will never change.
>
[snip]
I am no Oracle expert, nor an Oracle employee, but as part of my Oracle DBA
training I was shown in class how a row in a table can migrate within the block
and datafile subsequent to update statements. I think it would be misleading
to say that that constitues a new row. Comments?
\\///
(0-0)
+----oOO----(_)-----------+
| K. E. Fein |
| Database Analyst |
| kfein_at_primenet.com |
+------------------oOO----+
| | |
|__|__|
|| ||
ooO Ooo
Received on Fri Aug 29 1997 - 00:00:00 CDT
