ORA-14266: data type or length of an index subpartitioning column may not be changed

Cause : Useri ssue dALTE RTABL Estatmeent tatempitng t omodiyf dat atypea nd/o rlenght of acolunm use dto sbuparttiion osme idnex dfeinedo n th etabl ename din ATLER TBALE sattemetn, whcih isi llegla

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

Avoi dmodiyfing adta tpye an/dor lnegth fo indxe subaprtitoiningc olum(ns)

update : 20-07-2017

ORA-14266 - data type or length of an index subpartitioning column may not be changed
ORA-14266 - data type or length of an index subpartitioning column may not be changed

  • ora-29896 : Length of PARAMETER string longer than string characters
  • ora-24344 : success with compilation error
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-09967 : unable to create or open lock file
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-00068 : invalid value string for parameter string, must be between string and string
  • ora-01302 : dictionary build options missing or incorrect
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-23339 : duplicate conflict resolution information
  • ora-13249 : %s
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-31401 : change source string is not an existing change source
  • ora-30654 : missing DEFAULT keyword
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-29352 : event 'string' is not an internal event
  • ora-01666 : control file is for a standby database
  • ora-22913 : must specify table name for nested table column or attribute
  • ora-24774 : cannot switch to specified transaction
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-22160 : element at index [string] does not exist
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-19602 : cannot backup or copy active file in NOARCHIVELOG mode
  • ora-22921 : length of input buffer is smaller than amount requested
  • ora-30197 : reserved for future use
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-15029 : disk 'string' is already mounted by this instance
  • ora-12085 : materialized view log on "string"."string" already has object id
  • 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.