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 : 29-06-2017

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-12707 : error while getting create database NLS parameter string
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-16769 : the physical standby database is open read-only
  • ora-12443 : policy not applied to some tables in schema
  • ora-13262 : geometry column string does not exist in table string
  • ora-25456 : rule set was modified or evaluation terminated for iterator: string
  • ora-32633 : MODEL subquery FOR cell index returns too many rows
  • ora-16781 : the status of redo transport service for a database is unknown
  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-24007 : invalid value string, MAX_RETRIES should be non-negative integer
  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-13278 : failure to convert SRID to native format
  • ora-29289 : directory access denied
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-12032 : cannot use rowid column from materialized view log on "string"."string"
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-39167 : Tablespace string was not found.
  • ora-15195 : Internal ASM testing event number 15195
  • ora-29963 : missing BINDING keyword
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-19638 : file string is not current enough to apply this incremental backup
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-16247 : DDL skipped on internal schema
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-08432 : raw data has invalid floating point data
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-19815 : WARNING: string of string bytes is string%% used, and has string remaining bytes available.
  • ora-16789 : missing standby redo logs
  • 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.