Expand To Show Full Article
Oracle Error ORA-14041: partition bound may not be specified for resulting partitions - Developer Publish

Oracle Error ORA-14041: partition bound may not be specified for resulting partitions

Oracle Error Message

ORA-14041: partition bound may not be specified for resulting partitions

Reason for the Error

while parsing an ALTER {TABLE|INDEX} SPLIT PARTITION statement, of a resulting partition was found to contain VALUES LESS THAN clause which is illegal

Solution

remove VALUES LESS THAN clause from the description(s) of partitions resulting from splitting an existing table or index partition