Oracle database error code ORA-14009 – partition bound may not be specified for a LOCAL index partition

Oracle Database Error Code ORA-14009 Description :
partition bound may not be specified for a LOCAL index partition
Error 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

How to Solve :
remove all VALUES LESS THAN clauses from descriptions of LOCAL index partitions


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»