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

RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


ORA-08413: invalid compiler type in FORMAT parameter at string

1 Answers  


ORA-32401: materialized view log on "string"."string" does not have new values

1 Answers  


ORA-32774: more than one file was specified for bigfile tablespace string

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  






ORA-07345: The datafile name must not contain the string '..'.

1 Answers  


ORA-07548: sftopn: Maximum number of files already open

1 Answers  


ORA-12700: invalid NLS parameter value (string)

1 Answers  


ORA-32636: Too many rules in MODEL

1 Answers  


CLSR-00503: Error number encountered when creating an EVM event

1 Answers  


ORA-28264: Client identifier is too long

1 Answers  


ORA-02310: exceeded maximum number of allowable columns in table

1 Answers  


Categories