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
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!
Click Here to Expand Forum to Full Width