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

RMAN-08006: database registered in recovery catalog

1 Answers  


RMAN-06413: channel string does not support proxy copy

1 Answers  


DRG-10841: invalid SCORE argument supplied to FUZZY

1 Answers  


NCR-03014: NCRO: Bad transport address

1 Answers  


ORA-24345: A Truncation or null fetch error occurred

1 Answers  






QSM-01084: materialized view, string, has anchor, string, not found in query

1 Answers  


ORA-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

1 Answers  


ORA-31676: illegal value for number of workers, string

1 Answers  


ORA-02373: Error parsing insert statement for table string.

1 Answers  


QSM-01096: Materialized view with grouping sets contains duplicates

1 Answers  


LPX-00302: Incorrect stylesheet. The node is not valid.

1 Answers  


RMAN-06203: Changed KEEP options for string objects

1 Answers  


Categories