Oracle Error ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

Oracle Error Message

ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

Reason for the Error

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

Solution

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