ORA-14641: STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition

Cause : Specfiyinga STOER-IN lcaused urin gCREAET/ALTRE of aRang,e ComopsiteR angeL ist aprtitoined atble hwich si nota llowde"

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

Re-issue teh staemnt atfer rmeovin gthe TSORE-NI clasue

update : 24-07-2017
ORA-14641

ORA-14641 - STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition
ORA-14641 - STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition

  • ora-19699 : cannot make copies with compression enabled
  • ora-02063 : preceding stringstring from stringstring
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-25327 : Array size is invalid
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-16611 : operation aborted at user request
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-00320 : cannot read file header from log string of thread string
  • ora-28345 : cannot downgrade because there exists encrypted column
  • ora-16004 : backup database requires recovery
  • ora-36276 : (XSCGMDLAGG06) The current operator does not need a weight variable.
  • ora-16009 : remote archive log destination must be a STANDBY database
  • ora-13273 : dimension metadata table string does not exist
  • ora-39045 : invalid metadata remap name string
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-32004 : obsolete and/or deprecated parameter(s) specified
  • ora-30398 : illegal JOIN KEY clause
  • ora-38905 : DML error logging is not supported for LONG column "string"
  • ora-02311 : cannot alter with COMPILE option a valid type with type or table dependents
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-02007 : can't use ALLOCATE or DEALLOCATE options with REBUILD
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-29851 : cannot build a domain index on more than one column
  • ora-13046 : invalid number of arguments
  • ora-02268 : referenced table does not have a primary key
  • ora-14116 : partition bound of partition "string" is too long
  • ora-01573 : shutting down instance, no further change allowed
  • ora-19640 : datafile checkpoint is SCN string time string
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-16607 : one or more databases have failed
  • 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.