ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

You are here: Home // Oracle 11g // ORA-14054: invalid ALTER TABLE TRUNCATE PARTITION option

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

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

Database version: Oracle 11g Release 2 (11.2)