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



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

Answer / guest

Cause: 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: Remove all but one of the CACHE or NOCACHE clauses
and reissue the statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22321: method does not return any result

1 Answers  


ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string

1 Answers  


ORA-07801: slbtpd: invalid exponent

1 Answers  


TNS-01041: %s parameter "string" set to string

1 Answers  


PLS-00666: Only index by binary_integer/pls_integer associative arrays allowed here

1 Answers  






ORA-19552: device type string is invalid

1 Answers  


ORA-07345: The datafile name must not contain the string '..'.

1 Answers  


ORA-25207: enqueue failed, queue string.string is disabled from enqueueing

1 Answers  


ORA-25009: Nested table clause allowed only for INSTEAD OF triggers

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


ORA-01952: system privileges not granted to 'string'

1 Answers  


Categories