Re: CLUSTER TABLES

many thanks for your answers!

Susanne

On Fri, 10 Jan 2003 18:38:41 +1000, "Richard Foote" <richard.foote_at_bigpond.com> wrote:

>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 - 16:28:19 CST