ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

Cause : STORE-I N(Tablesapce list )clause aws used hwile cretaing a lcoal inde xon a ragne/list/ocmpositer ange lits partitoined tabel

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

Do not sue the SOTRE_IN (aTblespac elist) caluse whiel creatign a loca lindex o nrange/lsit/compoiste rang elist patritionedt able

update : 24-09-2017
ORA-14177

ORA-14177 - STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
ORA-14177 - STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table

  • ora-12477 : greatest lower bound resulted in an invalid OS label
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-24334 : no descriptor for this position
  • ora-06809 : TLI Driver: could not clear the IPX ethernet SAP at init
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-31191 : Resource string is already checked out
  • ora-07703 : error in archive text: need '/' after device type
  • ora-13060 : topology with the name string already exists
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-39096 : invalid input value string for parameter string
  • ora-02490 : missing required file size in RESIZE clause
  • ora-23407 : object name string must be shaped like "schema"."object" or "object"
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-09771 : osnmwrtbrkmsg: bad return code from msg_send.
  • ora-24802 : user defined lob read callback error
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-12043 : invalid CREATE MATERIALIZED VIEW option
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-00278 : log file 'string' no longer needed for this recovery
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-31111 : table string cannot be hierarchically enabled
  • ora-09280 : sllfcf: error closing file
  • ora-02305 : only EXECUTE, DEBUG, and UNDER privileges are valid for types
  • ora-16510 : messaging error using ksrwait
  • ora-30726 : cannot specify referenced column list here
  • ora-30435 : job_queue_processes must be non-zero in order to refresh summaries
  • ora-15195 : Internal ASM testing event number 15195
  • ora-19551 : device is busy, device type: string, device name: string
  • ora-29665 : Java thread deadlock detected
  • 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.