Oracle Error ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

Oracle 131 Views 0 Min Read

Oracle Error Message

ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

Reason for the Error

An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, BACKUP, ALLOCATE EXTENT, or DEALLOCATE UNUSED was specified in an ALTER TABLE MODIFY PARTITION statement for a Range or Composite Range partition.

Solution

Specify only legal options.

Tags: