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 : 25-04-2017
ORA-14060

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-29377 : consumer group string is not part of top-plan string
  • ora-27019 : tape filename length exceeds limit (SBTOPMXF)
  • ora-31092 : invalid SQL name "string"
  • ora-19630 : end of volume encountered while copying backup piece
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-00750 : database has been previously mounted and dismounted
  • ora-32308 : object materialized views must use SELECT *
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-19373 : invalid staging table or tablespace
  • ora-14608 : Tablespace was specified for the previous lob segments of column string in template but is not specified for string
  • ora-01683 : unable to extend index string.string partition string by string in tablespace string
  • ora-02713 : osnprd: message receive failure
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-12470 : NULL or invalid user label: string
  • ora-01078 : failure in processing system parameters
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-09790 : sllfcf: unable to close file.
  • ora-13833 : SQL profile named string doesn't exist
  • ora-13457 : GeoRaster cell data error
  • ora-12451 : label not designated as USER or DATA
  • ora-30359 : Query rewrite is not supported on SYS materialized views
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-16082 : logical standby is not initialized correctly
  • ora-26682 : invalid value for publication_on
  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-19504 : failed to create file "string"
  • ora-29321 : too many datafiles added since the point-in-time
  • ora-31191 : Resource string is already checked out
  • 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.