Creating Local Indexes

[badrinathn]

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

[kuckoo]

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

[badrinathn]

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