ORA-22326: cannot change a type to FINAL if it has subtypes

Cause : A nattepmtw a smdaet oc hnag eat yep iwt hsbutpye st oFNIA.L

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

Dorpa l lsbutpye so fteh atregtt yep ebfroec hnagnigi tt oF IANL.

update : 27-06-2017
ORA-22326

ORA-22326 - cannot change a type to FINAL if it has subtypes
ORA-22326 - cannot change a type to FINAL if it has subtypes

  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-00273 : media recovery of direct load data that was not logged
  • ora-14081 : new partition name must differ from the old partition name
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-37157 : MDX syntax error was found in MDX query string but error text was missing
  • ora-00030 : User session ID does not exist.
  • ora-19616 : output filename must be specified if database not mounted
  • ora-30512 : cannot modify string.string more than once in a transaction
  • ora-37082 : Invalid percent
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-29541 : class string.string could not be resolved
  • ora-15064 : communication failure with ASM instance
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-01536 : space quota exceeded for tablespace 'string'
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-06555 : this name is currently reserved for use by user SYS
  • ora-07212 : slcpu: times error, unable to get cpu time.
  • ora-30772 : opaque types do not have default constructors
  • ora-12853 : insufficient memory for PX buffers: current stringK, max needed stringK
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-31151 : Cyclic definition encountered for string: "string"
  • ora-28275 : Multiple mappings for user nickname to LDAP distinguished name exist.
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-31015 : Attempted to insert entry without name
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-01350 : must specify a tablespace name
  • ora-12601 : TNS:information flags check failed
  • ora-12667 : Shared server: outbound transport protocol different from inbound
  • 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.