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 : 26-05-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-12817 : parallel query option must be enabled
  • ora-39005 : inconsistent arguments
  • ora-00129 : listener address validation failed 'string'
  • ora-30112 : multiple values not allowed for parameter 'string'
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-12633 : No shared authentication services
  • ora-00399 : corrupt change description in redo log
  • ora-07622 : smscre: $CREATE failure
  • ora-38419 : invalid identifier in attribute : string
  • ora-01292 : no log file has been specified for the current LogMiner session
  • ora-28031 : maximum of string enabled roles exceeded
  • ora-16072 : a minimum of one standby database destination is required
  • ora-30695 : JDWP message format problem
  • ora-31438 : duplicate change table string
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-00230 : operation disallowed: snapshot control file enqueue unavailable
  • ora-24397 : error occured while trying to free connections
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-12422 : max policies exceeded
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-00355 : change numbers out of order
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-15056 : additional error message
  • ora-15061 : ASM operation not supported [string]
  • ora-30187 : reserved for future use
  • ora-25282 : message id. not provided for non-repudiation
  • ora-25312 : Cannot specify nonzero sender protocol
  • ora-12341 : maximum number of open mounts exceeded
  • ora-13109 : spatial table string exists
  • 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.