Re: What is the rowid composed of?

From: Robert <boobie.webdeveloper_at_mailnull.com>
Date: Wed, 12 Oct 2005 18:39:59 -0400
Message-ID: <dik31r$ji0$1@reader1.panix.com>

"HansF"
> Hmmmm. Perhaps we should ask for a correction to the Oracle9i Concepts
> manual, chapter 12 (Native Datatypes) section titled 'Physical Rowid', in
> which it states:
>
> "
> Oracle guarantees that as long as the row exists, its rowid does not
> change.
> "
>
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm#6538
>
> (Yes, there are caveats, conditions, and added information that neither
> your statement nor mine provide on the surface.)

Why would you quote a SINGLE sentence in that huge document to make a point ???
This is rather unlike you.

Exact same "sentence" they "said" since 8i http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm#6538 Yet 4~5 sentences away: " A row's assigned rowid remains unchanged unless ........."

So I stand by my original statement
> Within the same session - yes.
> Otherwise NO guranttee on rowid NOT changing.
Received on Wed Oct 12 2005 - 17:39:59 CDT