Lord, this one just runs and runs, doesn't it! It changed with the release
of 8.0, not 8i.
Regards
HJR
"andrew" <andrew_at_info.nl> wrote in message
news:3bb98e4f$0$218$4d4ebb8e_at_news.nl.uu.net...
> 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 - 15:28:26 CDT
