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



ORA-14186: number of sub-partitions of LOCAL index must equal that of the underlying table..

Answer / guest

Cause: User attempted to create a LOCAL partitioned index
with a number of sub-partitions which is different from that
of the underlying table.

Action: Correct the CREATE INDEX statement to specify a
correct number of sub-partitions

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09793: szguns: length of user name is greater than buffer.

1 Answers  


PCC-02353: Semantic error at line number, column number, file string:

1 Answers  


ORA-23463: flavor incompatible with object "string"."string"

1 Answers  


PCC-02203: found end of file when not expected

1 Answers  


ORA-09941: Version of orapasswd or installer is older than file.

1 Answers  






PCC-02444: Invalid combination of descriptor and non-descriptor clauses

1 Answers  


ORA-30460: 'string.string' cannot be refreshed because it is marked UNUSABLE

1 Answers  


ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 Answers  


PLS-00227: subprogram 'in' formal string is not yet denotable

1 Answers  


ORA-00710: new tablespace name is the same as the old tablespace name

1 Answers  


DRG-52204: error while registering index

1 Answers  


ORA-32773: operation not supported for smallfile tablespace string

1 Answers  


Categories