Re: Does anyboyd know how many bytes are in the ROWID ??

On Tue, 02 Oct 2001, maggie-evans_at_home.com wrote:

> It has changed since 8.0.

Are you sure?

,----[ From 8i docs ]
| For each row in the database, the ROWID pseudocolumn returns a
| row's address. Oracle8i rowid values contain information
| necessary to locate a row:
|
| The data object number of the object
|
| Which data block in the datafile
|
| Which row in the data block (first row is 0)
|
| Which datafile (first file is 1). The file number is relative to
| the tablespace.

`----

,----[ From 9i docs ]
| For each row in the database, the ROWID pseudocolumn returns a
| row's address. Oracle9i rowid values contain information
| necessary to locate a row:
|
| The data object number of the object
|
| Which data block in the datafile
|
| Which row in the data block (first row is 0)
|
| Which datafile (first file is 1). The file number is relative to
| the tablespace.

`----

This seems to say they are the same size. Where did you read the rowid size changed?

-- 
Galen Boyer
Sweet dreams and flying machines in pieces on the ground.