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

The following is the cause of this 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.

Action you can take to resolve this issue: Remove all but one of the CACHE or NOCACHE clauses and reissue the statement.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related