ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option



ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option..

Answer / guest

Cause: Name of the partition to be truncated may be followed
by DROP STORAGE or REUSE STORAGE

Action: Ensure that no options besides DROP STORAGE or REUSE
STORAGE are specified with ALTER TABLE TRUNCATE PARTITION

Please add more information about this Error

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

DRG-10836: field section and attribute section can not be nested

1 Answers  


ORA-14321: cannot add/drop values to DEFAULT partition

1 Answers  


ORA-29355: NULL or invalid string argument specified

1 Answers  


TNS-00223: numbernumbernumbernumber

1 Answers  


ORA-01125: cannot disable media recovery - file string has online backup set

1 Answers  






ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


ORA-00068: invalid value string for parameter string, must be between string and string

1 Answers  


PLS-01907: : number precision too large

1 Answers  


PLS-00995: unhandled exception # string

1 Answers  


ORA-25236: buffer too small for user data

1 Answers  


ORA-13240: specified dimensionality greater than that of the query mbr

1 Answers  


DRG-12213: cannot create/drop section group or sections for other user

1 Answers  


Categories