Re: Newbie Oracle ROWID questions

From: wayne <no_at_email.please.com>
Date: 12 May 2001 00:30:00 GMT
Message-ID: <9di068$3jv@dispatch.concentric.net>

> An update won't change the rowid. To change the rowid of a row you would
> have to delete the row and insert it. A row that gets larger and needs to
be
> chained to another block will still have the original rowid.

Sorry, I remembered it wrong. Somewhere I read that updating could move the entire row somewhere else, it must have been for an older version...

> One caveat is to not store the rowid somewhere and use it days later. If
> someone did an export, drop the table, and a reimport the rowids would
then
> be different.

Either that, or if the DBA wanted to optimize the storage by using ALTER TABLE MOVE or anything like that. Received on Fri May 11 2001 - 19:30:00 CDT