Oracle DBA, How To, Error, Cause and Action

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


Cause:


while parsing a CREATE INDEX statement to create a LOCAL partitioned index, 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

No comments:

Post a Comment

Thanks for your comment.