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 : 17-08-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-29865 : indextype is invalid
  • ora-38779 : cannot create restore point - too many restore points.
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-01757 : Must specify an object number
  • ora-07682 : sou2os: set kernel dispatch fail err
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-07607 : szaud: $SNDOPR failure
  • ora-31498 : description and remove_description cannot both be specified
  • ora-01952 : system privileges not granted to 'string'
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-01901 : ROLLBACK keyword expected
  • ora-06732 : TLI Driver: cannot alloc t_discon
  • ora-27044 : unable to write the header block of file
  • ora-22150 : variable-length array has not been initialized
  • ora-23460 : missing value for column string in resolution method "string" for "string"."string"."string"
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-32613 : not a MODEL cell
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-02091 : transaction rolled back
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-12728 : invalid range in regular expression
  • ora-13386 : commit/rollback operation error: [string]
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-37043 : (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
  • ora-01081 : cannot start already-running ORACLE - shut it down first
  • ora-25451 : too many attribute values for variable: string
  • 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.