Re: CLUSTER TABLES

Hi Susanne,

This might sound all a bit obvious but I wasn't 100% sure when I saw this (only 99.42% sure) so I went to the 9.2 SQL reference manual, searched on Cluster (because it's a pretty big page these days) and found this juicy piece of info:

"You can not partition a table that is part of a cluster"

Subsequent test proved it correct.

Cheers

Richard
"Susanne" <laloca_at_warum.net> wrote in message news:188p1vsfltni3kc8t721ffuuh6oqiukga1_at_4ax.com...
> 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
> >>
> >>
> >>
> >
>
Received on Fri Jan 10 2003 - 02:38:41 CST