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 : 24-05-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-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-16018 : cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-24052 : cannot propagate object type payloads with LOB attributes to an 8.0 release
  • ora-28508 : invalid value string for Heterogeneous Services initialization parameter string
  • ora-07751 : slemcr: malloc failure
  • ora-14627 : Invalid operation was specified on a GLOBAL partitioned index
  • ora-27191 : sbtinfo2 returned error
  • ora-07275 : unable to send signal to process
  • ora-28239 : no key provided
  • ora-38726 : Flashback database logging is not on.
  • ora-12729 : invalid character class in regular expression
  • ora-13464 : error loading GeoRaster data: string
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-08119 : The new initrans will make the index too big
  • ora-06006 : NETASY: dialogue execute failure
  • ora-24280 : invalid input value for parameter string
  • ora-07588 : spdcr: $GETJPIW get image name failure
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-24808 : streaming of lob data is not allowed when using lob buffering
  • ora-30063 : Internal Event to Test NTP
  • ora-04016 : sequence string no longer exists
  • ora-38718 : Invalid thread number specified in the DUMP FLASHBACK command.
  • ora-13111 : cannot add topo_geometry layer [string] to topology
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-08468 : mask option string is not supported
  • ora-02254 : DEFAULT not allowed here
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-19005 : Duplicate XMLType LOB storage option
  • 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.