ORA-14049: invalid ALTER TABLE MODIFY PARTITION option



ORA-14049: invalid ALTER TABLE MODIFY PARTITION option..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-12819: missing options in PARALLEL clause

1 Answers  


PCB-00581: "string" used as both host variable and indicator

1 Answers  


ORA-13500: SYSAUX DATAFILE clause specified more than once

1 Answers  


DRG-12422: write to client failed

1 Answers  






ORA-07283: sksaprd: invalid volume size for archive destination.

1 Answers  


ORA-07597: spguns: $GETJPIW failure

1 Answers  


ORA-01022: database operation not supported in this configuration

1 Answers  


ORA-00962: too many group-by / order-by expressions

1 Answers  


IMG-00804: Syntax error in attribute string

1 Answers  


ORA-39078: unable to dequeue message for agent string from queue "string"

1 Answers  


SQL*Loader-00600: Bind size of number bytes increased to number bytes to hold 1 row.

1 Answers  


Categories