I have a table which has partitions. What I want to do is to create index for each partition, one at the time.

In the past I have used the syntax:

CREATE BITMAP INDEX IDX_FACT_INV_TIME ON
GLX_FACT_INVENTORY(TIME_KEY)
LOCAL
(
PARTITION P1037 TABLESPACE FACT_INV_01,
PARTITION P1121 TABLESPACE FACT_INV_02,
PARTITION P1191 TABLESPACE FACT_INV_03,
PARTITION P1254 TABLESPACE FACT_INV_04,
PARTITION P1290 TABLESPACE FACT_INV_05,...etc
);

to create the index.

I cannot find any other syntax for creating index for partitioned table, is it even possible to create index for one partition at the time?


Thanx for your help in advance!
Fiona