Re: What is the rowid composed of?

From: HansF <News.Hans_at_telus.net>
Date: Wed, 05 Oct 2005 14:37:05 GMT
Message-Id: <pan.2005.10.05.14.35.44.704146@telus.net>

On Tue, 04 Oct 2005 21:47:04 -0400, Boobie interested us by writing:

>
> "Robert Wehofer"

>> several times with same result?

> Within the same session - yes.
> Otherwise NO guranttee on rowid NOT changing.

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.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup posts ***

Received on Wed Oct 05 2005 - 09:37:05 CDT