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

Here's the evidence that the length did not change between 8i and 9i:

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL> select length(rowid) from dual;
LENGTH(ROWID)

           18

Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production With the Partitioning option
JServer Release 8.1.7.1.1 - Production
SQL> select length(rowid) from dual;
LENGTH(ROWID)

           18

Andre

"Thomas Gaines" <tanguero_at_pcisys.net> wrote in message news:3BB93CD5.22B1ADC8_at_pcisys.net...
> 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 Tue Oct 02 2001 - 04:52:14 CDT