SQL Performance (MOSC)

MOSC Banner

ORA-14024: number of partitions of LOCAL index must equal that of the underlying table

edited Jul 18, 2020 5:07AM in SQL Performance (MOSC) 14 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center