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-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

1 Answers  


ORA-27191: sbtinfo2 returned error

1 Answers  


PCB-00227: Undeclared indicator variable "string"

1 Answers  


NNC-00052: client and server protocol versions are incompatible

1 Answers  


ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

1 Answers  






ORA-39726: unsupported add/drop column operation on compressed tables

1 Answers  


ORA-28045: SSL authentication between database and OID failed

1 Answers  


PCB-00214: JUSTIFIED clause not allowed for host variable "string"

1 Answers  


ORA-13505: SYSAUX tablespace can not be made read only

1 Answers  


ORA-38707: Media recovery is not enabled.

2 Answers  


ORA-30754: column or table string stores objects of only one type

1 Answers  


LPX-00247: invalid Document Type Declaration (DTD)

1 Answers  


Categories