Oracle Database 12c New Features

ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

ORA-14049: invalid ALTER TABLE MODIFY PARTITION option


Cause:


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.



Action:


Specify only legal options.