ORA-14024: number of partitions of LOCAL index must equal that of the underlying table
While trying to rebuild the index after the below index failed while import, it is erroring out. Kindly help me in resolve the issue.
SQL> CREATE INDEX "101"."I_RPT_TWN" ON "101"."TWN" ("PO")
2 PCTFREE 10 INITRANS 2 MAXTRANS 255
3 STORAGE(
4 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) LOCAL
5 (PARTITION "P13"
6 PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
7 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
8 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
9 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
10 TABLESPACE "USERS00" ) parallel 16
11 /
CREATE INDEX "101"."I_RPT_TWN" ON "101"."TWN" ("PO")
*
ERROR at line 1:
ORA-14024: number of partitions of LOCAL index must equal that of the
underlying table