ORA-22341: cannot assign supertype instance to subtype

Cause : An tatemtp wa smad eto sasig nor ocpy asupretyp einsatncet o ac ontianer( desitnatoin) htat acn olny hlod as ubtpye isntanec.

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

Mak esur ether untmie tpye o fthes ourec oft he sasigmnento r cpoy i sthes amet ypea s teh detsinaiton ro isa sutbypeo f teh detsinaiton ytpe

update : 26-07-2017
ORA-22341

ORA-22341 - cannot assign supertype instance to subtype
ORA-22341 - cannot assign supertype instance to subtype

  • ora-07455 : estimated execution time (string secs), exceeds limit (string secs)
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-09837 : addCallback: could not add allocate a callback link.
  • ora-31411 : change set string is referenced by a change table
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-28165 : proxy 'string' may not specify password-protected role 'string' for client 'string'
  • ora-25205 : the QUEUE string.string does not exist
  • ora-39088 : file name cannot contain a path specification
  • ora-24001 : cannot create QUEUE_TABLE, string already exists
  • ora-00215 : must be at least one control file
  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • ora-14260 : incorrect physical attribute specified for this partition
  • ora-39783 : Invalid direct path transaction active
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-23489 : duplicate entry "string"
  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-22606 : pickler image handle [string] is not well-formed
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-16550 : truncated result
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-12597 : TNS:connect descriptor already in use
  • ora-16701 : generic resource guard request failed
  • ora-13914 : Threshold notification failed.
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • 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.