Oracle Solution for Error ora-12814

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

What triggered 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.

What should we do to fix it:

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