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

PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 Answers  


ORA-28137: Invalid FGA audit Handler

1 Answers  


TNS-01081: Started with pid=string

1 Answers  


ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


ORA-24905: invalid recepient protocol attribute passed into OCI call

1 Answers  


RMAN-03039: Spooling for log turned off

1 Answers  


ORA-03211: The segment does not exist or is not in a valid state

1 Answers  


ORA-09915: Password encryption failed.

1 Answers  


ORA-10906: Unable to extend segment after insert direct load

1 Answers  


NNL-00022: error changing trace level from string to string, level change ignored

1 Answers  


ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.

1 Answers  


Categories