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 : 25-04-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-30388 : name of the rewrite equivalence is not specified
  • ora-39004 : invalid state
  • ora-12540 : TNS:internal limit restriction exceeded
  • ora-30072 : invalid time zone value
  • ora-16000 : database open for read-only access
  • ora-38605 : FI not enough memory(stringK) for candidate generation(stringK)
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-22321 : method does not return any result
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-39209 : Parameter string requires privileges.
  • ora-21520 : database server driver not installed
  • ora-06138 : NETTCP: error during connection handshake
  • ora-01930 : auditing the object is not supported
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-06413 : Connection not open.
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-01864 : the date is out of range for the current calendar
  • ora-32839 : property string is reserved, names with MGWPROP$_ prefix are not valid
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-08260 : ora_addr: cannot open nameserver
  • ora-16511 : messaging error using ksrget
  • ora-22306 : type "string"."string" already exists
  • ora-09217 : sfsfs: failed to resize file
  • ora-28661 : Object already has COMPRESS clause specified
  • ora-38723 : Invalid SCN expression.
  • ora-02224 : EXECUTE privilege not allowed for tables
  • 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.