ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index

Cause : User attempted to create a UNIQUE partitioned index whose sub-partitioning columns do not form a subset of its key columns which is illegal

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

If the user, indeed, desired to create an index whose subpartitioning columns do not form a subset of its key columns, it must be created as non-UNIQUE; otherwise, correct the list of key and/or subpartitioning columns to ensure that the index' subpartitioning columns form a subset of its key columns

update : 22-07-2017

ORA-14188 - sub-partitioning columns must form a subset of key columns of a UNIQUE index
ORA-14188 - sub-partitioning columns must form a subset of key columns of a UNIQUE index

  • ora-10261 : Limit the size of the PGA heap
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-23422 : Oracle Server could not generate an unused job number
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-28051 : the account is locked
  • ora-23456 : flavor string does not contain "string"
  • ora-02173 : invalid option for DROP TABLESPACE
  • ora-16115 : %s\% of LogMiner dictionary loading is done
  • ora-07634 : smsdbp: $CRETVA failure
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-19375 : no CREATE TABLE privilege on schema "string"
  • ora-19697 : standby control file not found in backup set
  • ora-16572 : Data Guard configuration file not found
  • ora-36198 : (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight.
  • ora-13366 : invalid combination of interior exterior rings
  • ora-13404 : invalid ultCoordinate parameter
  • ora-24360 : Type Descriptor Object not specified for Object Bind/Define
  • ora-23313 : object group "string"."string" is not mastered at string
  • ora-36271 : (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
  • ora-24365 : error in character conversion
  • ora-33302 : (DBVALID01) SEVERE ERROR: Record number multiply used.
  • ora-06141 : NETTCP: no privilege for user
  • ora-09261 : spdcr: error creating detached (background) process
  • ora-07496 : sppst: lm_post failed.
  • ora-16741 : the destination parameter of standby database "string" has incorrect syntax
  • ora-15090 : handle string is not a valid descriptor
  • ora-31527 : could not find source column string for CDC change table string.string
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-30980 : Invalid Input.
  • 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.