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 : 23-05-2017
ORA-21524

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

  • ora-39209 : Parameter string requires privileges.
  • ora-24068 : cannot start queue string, queue table string is being migrated
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-24350 : OCI call not allowed
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-08198 : Flashback Table is not supported on object tables, nested tables
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-39026 : master table is inconsistent on validation string
  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-30163 : The thread safety initialization failed
  • ora-10628 : Turn on sanity check for kdiss index skip scan state
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-19565 : BACKUP_TAPE_IO_SLAVES not enabled when duplexing to sequential devices
  • ora-32504 : expecting one of string, string, string, or string but found string
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-06407 : NETCMN: unable to set up break handling environment
  • ora-30452 : cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
  • ora-37130 : (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
  • ora-19202 : Error occurred in XML processingstring
  • ora-06137 : NETTCP: error during connection handshake
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-40254 : priors cannot be specified for one-class models
  • ora-16401 : archivelog rejected by RFS
  • ora-06706 : TLI Driver: service not found
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-34802 : (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.
  • 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.