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 : 17-08-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-19605 : input filename must be specified
  • ora-33072 : (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
  • ora-31659 : status message was invalid type - detaching job
  • ora-38410 : schema extension not allowed for the table name
  • ora-16131 : An error occurred during a Terminal Recovery of the standby.
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-24053 : PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative
  • ora-31419 : source table string does not exist
  • ora-39098 : Worker process received data objects while loading metadata. Invalid process order range is string..string
  • ora-00320 : cannot read file header from log string of thread string
  • ora-39600 : Queue keys needs to be a suffix of cluster key.
  • ora-23607 : invalid column "string"
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-08237 : smsget: SGA region not yet created
  • ora-14510 : can specify VALIDATE INTO clause only for partitioned tables
  • ora-28051 : the account is locked
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-06141 : NETTCP: no privilege for user
  • ora-01107 : database must be mounted for media recovery
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-24320 : unable to initialize a mutex
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-31512 : name cannot contain double quotation marks
  • ora-36863 : (XSTFRC03) The OLAPRC_TABLE function encountered an error while parsing the COLUMNMAP.
  • ora-24173 : nested query not supported for rule condition
  • ora-02759 : Not enough request descriptors available
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-09700 : sclin: maximum number of latches exceeded
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-29818 : column name not properly specified
  • 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.