ORA-14178: STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

Cause : STOREI N (DEAFULT) si vali donly ofr locla indeexs.

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

a) Spceify at ablesapce lits in palce ofD EFAUL,T or b )Remov eSTOREI N clasue ands pecif ytablepsaces nidividaully fro eachi ndex aprtitino.

update : 18-08-2017

ORA-14178 - STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
ORA-14178 - STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes

  • ora-07240 : slemrd: seek error.
  • ora-07201 : slhom: oracle_home variable not set in environment.
  • ora-30163 : The thread safety initialization failed
  • ora-25454 : error during evaluation of rule set: string.string for iterator: string
  • ora-01511 : error in renaming log/data files
  • ora-39099 : cannot create index for "string" on master table string
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-29258 : buffer too small
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-02202 : no more tables permitted in this cluster
  • ora-30576 : ConText Option dictionary loading error
  • ora-16606 : unable to find property "string"
  • ora-00133 : value of string is too long
  • ora-39107 : Master process string violated startup protocol. Master error:
  • ora-01699 : tablespace 'string' is being imported for point in time recovery
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-12482 : internal MLS error: string Error: string
  • ora-25256 : consumer cannot be specified with a single-consumer queue or an exception queue
  • ora-02283 : cannot alter starting sequence number
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-00600 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-32340 : cannot tune the materialized view definition
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-12511 : TNS:service handler found but it is not accepting connections
  • ora-06911 : CMX: t_event returns ERROR
  • 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.