Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-24333: zero iteration count

2 Answers   IBM,


TNS-02524: Authentication: privilege check failed

1 Answers  


IMG-00545: invalid cut values specified

1 Answers  


SQL*Loader-00609: value used for ROWS parameter changed from number to number

1 Answers  


ORA-02495: cannot resize file string, tablespace string is read only

1 Answers  






ORA-22898: existing scope clause on "string" points to a table other than the one mentioned in the referential constraint

1 Answers  


ORA-28665: table and partition must have same compression attribute

1 Answers  


ORA-15001: diskgroup "string" does not exist or is not mounted

1 Answers  


DRG-51030: wildcard query expansion resulted in too many terms

1 Answers  


ORA-25500: database is not open

1 Answers  


ORA-27027: sbtremove2 returned error

1 Answers  


NID-00604: No control files found in database

1 Answers  






Categories