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-00227: corrupt block detected in controlfile: (block string, # blocks string)

1 Answers  


TNS-12161: TNS:internal error: partial data received

1 Answers  


RMAN-06911: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


DRG-10834: upper-case form of section name string too long

1 Answers  


ORA-16758: The specified apply instance is not running.

1 Answers  






LPX-00655: Invalid output comment '~S'.

1 Answers  


DRG-50944: NEAR operator not supported for theme index

1 Answers  


ORA-06957: No SID is currently available

1 Answers  


ORA-22618: attribute is a BAD NULL in the image handle

1 Answers  


TNS-12633: No shared authentication services

1 Answers  


SQL*Loader-00281: Warning: ROWS parameter ignored in parallel mode.

1 Answers  


ORA-02046: distributed transaction already begun

1 Answers  


Categories