Creating Local Indexes

Hi,

I have a partioned table(rei_account) with 2 partitions part01 and part02.

I want to create an local index on the account_number, so that I can access the indexes along with the partition.


I am tring to create a local index, but 'am getting this error:
Please suggest

CREATE INDEX HLP_LOC_IDX ON ACC_PARTITION(ACCOUNT_NUMBER) LOCAL
(PARTITION PART01 ,PARTITION PART02)

Errror:
ERROR at line 1:
ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

Badrinath

dear friend
Don't give partition name with command.
no of index partition and index Partition name will be same as table partition.
CREATE INDEX HLP_LOC_IDX ON ACC_PARTITION(ACCOUNT_NUMBER) LOCAL


thanks
kuckoo

Hi,
Will that create 2 different indexes or only one index?
Clarify
If I want my query to use only one index, how do I specify it
Badrinath