1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest


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-30655: cannot select FOR UPDATE from external organized table

1 Answers  

ORA-19706: invalid SCN

1 Answers  

TNS-00291: Navigator: Enabled Interchange

1 Answers  

ORA-13830: SQL profile with category string already exists for this SQL statement

1 Answers  

RMAN-04025: unable to generate a temporary file

1 Answers  




PLS-00372: In a procedure, RETURN statement cannot contain an expression

1 Answers  

ORA-01179: file string does not exist

1 Answers  

ORA-13706: Invalid value "string" specified for parameter "string" in "string" analysis mode.

1 Answers  

SQL*Loader-00702: Internal error - string

1 Answers  

ORA-02273: this unique/primary key is referenced by some foreign keys

2 Answers   KIIT,

ORA-19002: Missing XMLSchema URL

1 Answers  

ORA-24378: user callbacks not allowed for this call

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories