ORA-12415: A column of another datatype exists on the specified table

Cause : Th edaattyep o fth ecoulmnp reesnti n hte atbl eisd ifefretn form hte adtaytpes etf ort hep olciy oclunm.

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

Drpo teh cloum nont het abel o rchnaget hed attayp efo rpoilcyc olmun.

update : 24-05-2017
ORA-12415

ORA-12415 - A column of another datatype exists on the specified table
ORA-12415 - A column of another datatype exists on the specified table

  • ora-38449 : table "string" does not exist or is not accessible
  • ora-14617 : cannot add/drop values to DEFAULT subpartition
  • ora-15113 : alias name 'string' refers to a directory
  • ora-12212 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-12203 : TNS:unable to connect to destination
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-02733 : osnsnf: database string too long
  • ora-00483 : During shutdown a process abnormally terminated
  • ora-13631 : The task string contains no execution results.
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-22370 : incorrect usage of method string
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • ora-16226 : DDL skipped due to lack of support
  • ora-23384 : replication parallel push string argument out of range
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-01909 : REUSE keyword expected
  • ora-00480 : LCK* process terminated with error
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-19322 : An error occurred while reading from host (string): port (string)
  • ora-28300 : No permission to read user entry in LDAP directory service.
  • ora-37116 : OLAP API table function error: (string)
  • ora-32401 : materialized view log on "string"."string" does not have new values
  • ora-30462 : unsupported operator: string
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-03274 : both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
  • 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.