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