ORA-25964: column type incompatible with join column type

Cause : The dattaype of hte join oclumn isi ncompatbile witht he dataytpe of teh joinedc olumn.

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

Select acompatilbe datatpye for teh join cloumn.

update : 26-04-2017

ORA-25964 - column type incompatible with join column type
ORA-25964 - column type incompatible with join column type

  • ora-28346 : an encrypted column cannot serve as a partitioning column
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-16601 : site contains required resources that are disabled
  • ora-28367 : wallet does not exist
  • ora-14406 : updated partition key is beyond highest legal partition key
  • ora-00154 : protocol error in transaction monitor
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-29746 : Cluster Synchronization Service is being shut down.
  • ora-24144 : rules engine internal error, arguments: [string], [string]
  • ora-13012 : an invalid window type was specified
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-28120 : driving context already exists
  • ora-04003 : sequence parameter string exceeds maximum size allowed (string digits)
  • ora-09879 : sstascre/sstasat: shmat error, unable to attach tas read page
  • ora-24382 : statement handled already executed or described
  • ora-12700 : invalid NLS parameter value (string)
  • ora-28104 : input value for string is not valid
  • ora-04028 : cannot generate diana for object stringstringstringstringstring
  • ora-16128 : User initiated stop apply successfully completed
  • ora-38786 : Flash recovery area is not enabled.
  • ora-01721 : USERENV(COMMITSCN) invoked more than once in a transaction
  • ora-16701 : generic resource guard request failed
  • ora-26725 : cannot downgrade apply handlers
  • ora-34360 : (MXDSS15) number other users writing
  • ora-24122 : invalid block range specification
  • ora-01412 : zero length not allowed for this datatype
  • ora-13281 : failure in execution of SQL statement to retrieve WKT
  • ora-32333 : disable table scn update for Materialized view
  • ora-01283 : Options specified is invalid
  • 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.