Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CLUSTER TABLES
Susanne wrote:
> can cluster tables be partitioned in 9.2 ?
>
> thanks,
>
> Susanne
>
> On Fri, 27 Dec 2002 02:57:20 GMT, "Jim Kennedy"
> <kennedy-down_with_spammers_at_attbi.com> wrote:
>
> >size of the primary key of the parent + ((size of the primary key of the
> >children)* # of children) -((size of the primary key of the parent)* # of
> >children)
> >
> >eg
> >parent is employee where the primary key is ssn (varchar2(9))
> >child is pay where the primary key is ssn (varchar2(9)) and date of payment
> >(date which is 7)
> >so if on average you have 300 children records then
> >9 + (300 * (9+7))- (300 * 9) or
> >9+ (300 * 7) = 2,109
> >
> >Jim
> >"Albert Punsola" <apunsola_at_hotmail.com> wrote in message
> >news:aufikr$6td$1_at_nsnmpen2-gest.nuria.telefonica-data.net...
> >> Hello ,
> >>
> >> someone knows to help me?
> >> someone knows how to calculate SIZE parameter when cluster object is
> >> calculate? someone knows the formula?
> >>
> >>
> >> thanks,
> >>
> >> Albert Punsola
> >>
> >>
> >>
> >
Are you trying to apply the meaning of the word "Cluster" from SQL Server to Oracle? They mean very different things.
Either way ... look it up as Jim suggests or at http://tahiti.oracle.com
Daniel Morgan Received on Wed Jan 08 2003 - 21:19:34 CST