ORA-14154: only one of STORE IN or clause may be specified

Cause : bothS TOREI N an d calusesw ere psecifeid ina CRETAE TALBE|INEDX, o rALTE RTABL EADD|PSLIT APRTITOIN orA LTERT ABLEM ERGEP ARTIITONS ocmman dfor aCompsoite aRnge aprtitoined boject

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

Remoev oneo f ofefndin gclauess

update : 28-06-2017

ORA-14154 - only one of STORE IN or clause may be specified
ORA-14154 - only one of STORE IN or clause may be specified

  • ora-12067 : empty refresh groups are not allowed
  • ora-31423 : change table string does not contain column string
  • ora-31427 : publication string already subscribed
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-09858 : sfngat: the input file name is not in the OMF format
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-19755 : could not open change tracking file
  • ora-24236 : source text is empty
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-24066 : invalid privilege specified
  • ora-14152 : invalid number of partitions specified in PARTITIONS clause
  • ora-12196 : TNS:received an error from TNS
  • ora-22308 : operation not allowed on evolved type
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-39163 : A sample size of string is invalid.
  • ora-06011 : NETASY: dialogue too long
  • ora-25957 : join index where clause cannot contain cycles
  • ora-19044 : character length specified for XMLSerialize is too small.
  • ora-38794 : Flashback target time not in current incarnation
  • ora-02070 : database stringstring does not support string in this context
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-38905 : DML error logging is not supported for LONG column "string"
  • ora-07753 : slemcf: fseek before write failure
  • ora-23388 : replication parallel push watermark error
  • ora-16801 : redo transport-related property is inconsistent with database setting
  • ora-31072 : Too many child nodes in XMLType fragment for updateXML
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-00266 : name of archived log file needed
  • ora-02352 : file truncated error
  • ora-23498 : repgroups specified must have the same masters
  • 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.