Re: Does anybody now how big the rowid in 9i is?

Maggie/Owen -

I'm not aware of any changes to the rowid in Oracle9i, but it certainly changed with Oracle8i. Perhaps that's what you're thinking of. In any case, I'll just take the easy way out and quote some Oracle educational material (Oracle9i DBA Fundamentals I):

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
An Extended ROWID needs 10 bytes of storage on disk and is displayed using 18 characters.
It consists of the following components: • Data object number is assigned to each data object, such as table or index when it is
created, and it is unique within the database. • Relative file number is unique to each file within a tablespace. • Block number represents the position of the block, containing the row, within the file.
• Row number identifies the position of the row directory slot in the block header.

Internally, the data object number needs 32 bits, the relative file number needs 10 bits, block
number needs 22 bits, and the row number needs 16 bits, adding up to a total of 80 bits or 10
bytes.

=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+

Hope this helps...

Tom Gaines Received on Mon Oct 01 2001 - 23:04:37 CDT