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

DRG-50918: mismatched close escape character

1 Answers  


ORA-12092: cannot online redefine replicated table "string"."string"

1 Answers  


RMAN-20211: FROM TIME is before RESETLOGS time

1 Answers  


ORA-04013: number to CACHE must be less than one cycle

1 Answers  


NNL-00240: Starting "string"...

1 Answers  






ORA-34348: (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.

1 Answers  


RMAN-06198: %-24s string bytes

1 Answers  


DRG-11303: secondary indexes are not supported by this indextype

1 Answers  


ORA-38724: Invalid option to the FLASHBACK DATABASE command.

1 Answers  


ORA-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


ORA-02781: Invalid value given for the timing wanted flag

1 Answers  


EXP-00087: Problem with internal hash table of schema/table names

1 Answers  


Categories