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

SQL*Loader-00518: Error reassembling file name (string)

1 Answers  


UDE-00010: multiple job modes requested, string and string.

1 Answers  


ORA-08106: cannot create journal table string.string

1 Answers  


ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the <LEAF: VALUE> format.

1 Answers  


SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.

1 Answers  


RMAN-20401: script already exists

1 Answers  


ORA-02235: this table logs changes to another table already

1 Answers  


RMAN-06057: a standby controlfile cannot be included along with a current controlfile

1 Answers  


ORA-02469: Hash expression does not return an Oracle Number.

1 Answers  


QSM-02049: subquery using the ANY clause in mv

1 Answers  


ORA-06134: NETTCP: file access privilege violation

1 Answers  


Categories