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 : 27-04-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-16539 : task element not found
  • ora-32846 : Messaging Gateway agent cannot be started; status is string
  • ora-17624 : Failed to delete directory string
  • ora-32633 : MODEL subquery FOR cell index returns too many rows
  • ora-30691 : failed to allocate system resources while registering a TCP/IP connection for data traffic detection
  • ora-01704 : string literal too long
  • ora-16109 : failed to apply log data from previous primary
  • ora-07501 : scgtoa: $deq unexpected return
  • ora-08451 : invalid specification of DB in picture mask
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-04002 : INCREMENT must be a non-zero integer
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-10387 : parallel query server interrupt (normal)
  • ora-01466 : unable to read data - table definition has changed
  • ora-38704 : Checksum error in flashback database log file header.
  • ora-27038 : created file already exists
  • ora-21601 : attribute is not an object
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-21526 : initialization failed
  • ora-27301 : OS failure message: string
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-21611 : key length [string] is invalid
  • ora-06570 : shared pool object does not exist, cannot be pinned
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-28006 : conflicting values for parameters string and string
  • ora-22062 : invalid input string [string]
  • ora-09796 : szrbuild: malloc of role name failed.
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-27063 : number of bytes read/written is incorrect
  • 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.