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

NNO-00611: disabling request forwarding

1 Answers  


ORA-25233: invalid parameter specified for NAVIGATION

1 Answers  


PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  


TNS-12537: TNS:connection closed

1 Answers   IBM,


ORA-14152: invalid number of partitions specified in PARTITIONS clause

1 Answers  






ORA-22922: nonexistent LOB value

1 Answers  


PLS-00705: exception 'string' used in expression requiring return type

1 Answers  


ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.

1 Answers  


RMAN-06550: clone database not mounted and db_name not set in init.ora

1 Answers  


ORA-06733: TLI Driver: failed to receive disconnect

1 Answers  


ORA-16214: apply stalled for apply delay

1 Answers  


ORA-13333: invalid LRS measure

1 Answers  


Categories