Oracle Error ORA-12814: only one CACHE or NOCACHE clause may be specified

Oracle Error Message

ORA-12814: only one CACHE or NOCACHE clause may be specified

Reason for the Error

CACHE was specified more than once, NOCACHE was specified more than once, or both CACHE and NOCACHE were specified in a CREATE TABLE or CLUSTER, or in an ALTER TABLE or CLUSTER statement.

Solution

Remove all but one of the CACHE or NOCACHE clauses and reissue the statement.