global partition syntax

From: Ron McCamish <rmccamish_at_cas.org>
Date: Fri, 11 Sep 1998 10:51:35 -0400
Message-ID: <35F938F7.72735D19@cas.org>

i'm trying to create this table:

create table test_part (

   constraint test_part_pk primary key (foo1)

      using index local (
         partition test_part_pk_p01
            tablespace data02
            storage(initial 1M next 1M pctincrease 0) pctfree 5,
         partition test_part_pk_p02
            tablespace data02
            storage(initial 1M next 1M pctincrease 0) pctfree 5

),

   constraint test_part_uq1 unique (foo2)

      using index global partition by range (foo2) (
         partition test_part_uq1_p01
            values less than (5)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5,
         partition test_part_uq1_p02
            values less than (10)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5,
         partition test_part_uq1_p03
            values less than (MAXVALUE)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5

),

   foo1  number,
   foo2  number,
   foo3  number,

   foo4 number
)

   partition by range (foo1) (

      partition test_part_p01 values less than (100)
         storage(initial 1M next 1M pctincrease 0) pctfree 5,
      partition test_part_p02 values less than (200)
         tablespace data01
         storage(initial 1M next 1M pctincrease 0) pctfree 5

);

and i get:

ERROR at line 12:
ORA-14038: GLOBAL partitioned index must be prefixed

yet the index is prefixed. when i try creating the index separately from the table like:

create unique index test_part_uq1 on test_part (foo2) global

   partition by range (foo2) (

         partition test_part_uq1_p01
            values less than (5)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5,
         partition test_part_uq1_p02
            values less than (10)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5,
         partition test_part_uq1_p03
            values less than (MAXVALUE)
               tablespace data02
               storage(initial 1M next 1M pctincrease 0) pctfree 5

);

this works fine. so i'm guessed the create table syntax is wrong.

any clues?

thanks,

ron....

Received on Fri Sep 11 1998 - 09:51:35 CDT