ORA-14627: Invalid operation was specified on a GLOBAL partitioned index

Cause : An invalid operation such as ALTER INDEX DROP|SPLIT SUBPARTITION was specified on the global index

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

Ensure that subpartition level operations are not specified on a GLOBAL index, since these are only RANGE partitioned

update : 27-06-2017

ORA-14627 - Invalid operation was specified on a GLOBAL partitioned index
ORA-14627 - Invalid operation was specified on a GLOBAL partitioned index

  • ora-01079 : ORACLE database was not properly created, operation aborted
  • ora-08179 : concurrency check failed
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-38851 : cannot mark the current instance (redo thread) as disabled
  • ora-01060 : array binds or executes not allowed
  • ora-24147 : rule string.string does not exist
  • ora-02819 : Write failed
  • ora-29547 : Java system class not available: string
  • ora-36840 : (XSLMGEN10) Cube string.string!string has no measures
  • ora-31505 : cannot alter or drop predefined change set
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-02052 : remote transaction failure at string
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-02706 : osnshs: host name too long
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-40217 : priors table mismatched with training data
  • ora-14174 : only a may follow COALESCE PARTITION|SUBPARTITION
  • ora-19912 : cannot recover to target incarnation string
  • ora-01276 : Cannot add file string. File has an Oracle Managed Files file name.
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-38709 : Recovery Area is not enabled.
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-12821 : invalid value for INSTANCES
  • ora-04060 : insufficient privileges to execute string
  • ora-19663 : cannot apply current offline range to datafile string
  • ora-06521 : PL/SQL: Error mapping function
  • 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.