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

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 2 Oct 2001 20:24:12 +1000
Message-ID: <3bb99558@news.iprimus.com.au>

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:3bb93457_at_post.newsfeeds.com...
> *** post for FREE via your newsreader at post.newsfeeds.com ***
>
> Hi Owen Brandon,
>
> extended rowid takes 10 bytes on most platforms.
> And AFAIR it has chaged since v7, not 8.

Nope. It changed in version 8.0, with the addition of the object number, thereby permitting 1022 data files per tablespace, not per database (which was the Oracle 7 limit).

Regards
HJR
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
>
> "Maggie Evans" <maggie-evans_at_home.com> wrote in message
> news:Fp9u7.42066$L8.9939424_at_news2.rdc1.bc.home.com...
> > How many bytes make up the rowid?
> > I need to know the row id to estimate the size of the index.
> > It has changed since 8.0. Does anybody know what it is?
> > Thanks for any help.
> >
> > cheers;
> > Owen Brandon
> >
> >
>
>
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 90,000 Newsgroups - 16 Different Servers! =-----
Received on Tue Oct 02 2001 - 05:24:12 CDT