Re: CLUSTER TABLES

9i, R1 gives the following error when attempting to create a clustered, partitioned table:

ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

I should imagine this to be the same result in 9i R2.

David Fitzjarrell

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E1CEA45.3561AC46_at_exesolutions.com>...
> 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 Thu Jan 09 2003 - 13:31:18 CST