ORA-22314: method information mismatch in ALTER TYPE

Cause : The number of methods or the method signature do not match that of the original type declaration. This is not supported.

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

Make sure the method signature stay identical for the previously declared method. Do not drop existing methods.

update : 28-05-2017

ORA-22314 - method information mismatch in ALTER TYPE
ORA-22314 - method information mismatch in ALTER TYPE

  • ora-19802 : cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
  • ora-01495 : specified chain row table not found
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-02236 : invalid file name
  • ora-01494 : invalid SIZE specified
  • ora-37027 : (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
  • ora-19335 : Invalid format type object
  • ora-01493 : invalid SAMPLE size specified
  • ora-07442 : function address must be in the range string to string
  • ora-01492 : LIST option not valid
  • ora-13865 : Module name must be specified
  • ora-24336 : invalid result set descriptor
  • ora-01010 : invalid OCI operation
  • ora-25247 : %s is not a recipient of specified message
  • ora-19204 : Non-scalar value 'string' is marked as XML attribute
  • ora-02706 : osnshs: host name too long
  • ora-24008 : queue table string.string must be dropped first
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-24772 : Cannot mix tightly-coupled and loosely-coupled branches
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-31158 : schema "string" currently being referenced
  • ora-06253 : NETNTT: cannot read arguments from address file
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-21605 : property [string] is not a property of value instances
  • ora-27374 : insufficient privileges on event source queue
  • ora-38725 : specified name "string" does not match actual "string"
  • ora-01222 : MAXINSTANCES of string requires MAXLOGFILES be at least string, not string
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • 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.