ORA-21524: object type mismatch

Cause : The object type of the object is different from what is specified.

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

Check the type of the object and correct it.

update : 25-06-2017

ORA-21524 - object type mismatch
ORA-21524 - object type mismatch

  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-02275 : such a referential constraint already exists in the table
  • ora-30748 : column string already enabled to store objects of type string.string
  • ora-26712 : remote object is "string"."string"@"string"
  • ora-39769 : finish is not allowed with an incompletely loaded last row
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-37117 : olapi history retention has been disabled
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-16632 : instance being added to database profile
  • ora-26711 : remote table does not contain a primary key constraint
  • ora-24805 : LOB type mismatch
  • ora-01597 : cannot alter system rollback segment online or offline
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-02151 : invalid tablespace name: string
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-27088 : unable to get file status
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-14005 : missing RANGE keyword
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-02177 : Missing required group number
  • ora-25256 : consumer cannot be specified with a single-consumer queue or an exception queue
  • ora-03241 : Invalid unit size
  • ora-13632 : The user cancelled the current operation.
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-13440 : GeoRaster metadata compression type error
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-40252 : no target values were found
  • ora-09923 : Can't spawn process - user log directory not created properly
  • 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.