Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: When does ROWID change ?
The rowid basically indicates the physical location of the row
on disk. One would think that it would be relatively safe to
use this as a key, but Oracle can, in some conditions, move
things around without you knowing it. For example, if your row
grows in size (i.e. due to a varchar increase in size), Oracle
can move the row to someplace else.
To sum up, the rowid is only good within a query or PL/SQL, and
should never be stored as a foreign key to another table.
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8504&cus_id=USENET&qtn_id=7354
Received on Mon Dec 13 1999 - 09:41:52 CST