ORA-14009: partition bound may not be specified for a LOCAL
index partition



ORA-14009: partition bound may not be specified for a LOCAL index partition..

Answer / guest

Cause: while parsing a CREATE INDEX statement to create a
LOCAL partitioned index, <partition-description> of one of
partitions was found to contain VALUES LESS THAN clause
which is illegal since a LOCAL index inherits partition
bounds from its base table

Action: remove all VALUES LESS THAN clauses from
descriptions of LOCAL index 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-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents

2 Answers   Wipro,


ORA-14400: inserted partition key does not map to any partition

1 Answers  


ORA-31658: specifying a schema name requires a table name

1 Answers  


ORA-13709: Required parameter "string" must be set before execution.

1 Answers  


LPX-00303: attribute value "~S" not expected for ~S

1 Answers  






ORA-24369: required callbacks not registered for one or more bind handles

1 Answers  


TNS-12662: proxy ticket retrieval failed

1 Answers  


ORA-23314: database is not a materialized view site for "string"."string"

1 Answers  


ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.

1 Answers  


ORA-27042: not enough space on raw partition to fullfill request

1 Answers  


ORA-02701: osnoraenv: error translating oracle image name

1 Answers  


IMG-00548: invalid interleave specified

1 Answers  


Categories