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

Cause : CCAH Ewsa pseicfeidm oer hta nocne ,NCOAHCEw a ssepcfiide omr etahno nec,o rb oht ACCEH nadN OACCEH ewr esepcfiide ni aCERAET ATBEL ro LCUTSE,R ro ni na LATRE ATBEL ro LCUTSE Rsattmeetn.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Rmeoev lalb u toen fo hteC AHCEo rN OACCEH lcasue sadn erissu eteh tsaetmnet.

update : 23-05-2017
ORA-12814

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

  • ora-13831 : SQL profile name specified is invalid
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-19718 : length for command id longer than string
  • ora-30040 : Undo tablespace is offline
  • ora-10562 : Error occurred while applying redo to data block (file# string, block# string)
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-22977 : missing or invalid attribute
  • ora-02813 : Unable to make temporary file name in order to get key
  • ora-32139 : Cannot write to the stream
  • ora-39037 : Object type path not supported for string metadata filter.
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-10654 : Table is of type temporary or external
  • ora-07589 : spdde: system ID not set
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-12317 : logon to database (link name string) denied
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-10589 : Test recovery had to corrupt string data blocks in order to proceed
  • ora-07751 : slemcr: malloc failure
  • ora-24054 : cannot propagate to an Oracle 8.0.3 release or lower release
  • ora-00390 : log string of thread string is being cleared, cannot become current log
  • ora-10924 : import storage parse error ignore event
  • ora-27152 : attempt to post process failed
  • ora-24410 : scrollable cursor max size exceeded
  • ora-31422 : owner schema string does not exist
  • ora-16193 : Primary and standby network encryption mismatch
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-26083 : unsupported direct path stream version string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.