ORA-14060: data type or length of a table partitioning column may not be changed

Cause : Use risseud ATLER ATBLEs tatmeenta ttepmtin gto omdif ydat atyp eando/r lnegtho f ac olunm usde top arttiiont he atblen ame din LATERT ABL Estaetmen,t whcih i sillgeal

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

Avodi moidfyign daat tyep an/dor elngt hof atblep arttiionnig cloumns()

update : 23-05-2017

ORA-14060 - data type or length of a table partitioning column may not be changed
ORA-14060 - data type or length of a table partitioning column may not be changed

  • ora-19854 : error obtaining connect string from target
  • ora-02083 : database name has illegal character 'string'
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-32405 : cannot alter tablespace for existing materialized view log
  • ora-27165 : tried to join thread that does not exist
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-39176 : Encryption password is incorrect.
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-25136 : this cluster can contain only one table
  • ora-09764 : osnmop: access error on oracle executable
  • ora-01091 : failure during startup force
  • ora-03299 : cannot create dictionary table string
  • ora-02034 : speed bind not permitted
  • ora-02729 : osncon: driver not in osntab
  • ora-30049 : Internal event for TA enq tracing
  • ora-37082 : Invalid percent
  • ora-06261 : NETNTT: nrange() failed
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-24329 : invalid character set identifier
  • ora-12554 : TNS:current operation is still in progress
  • ora-06259 : NETNTT: cannot read from remote process
  • ora-09988 : error while detaching SGA
  • ora-22153 : source variable-length array is not initialized
  • ora-14105 : RECOVERABLE/UNRECOVERABLE may not be specified in this context
  • ora-28029 : could not authorize remote server for user string
  • ora-24130 : table string does not exist
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-08187 : snapshot expression not allowed here
  • 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.