ORA-19271: XP0051 - invalid atomic type definition

Cause : The QName used as an AtomicType in a SequenceType was not defined in the in-scope type definitions as an atomic type.

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

Use the correct atomic type name.

update : 24-08-2017
ORA-19271

ORA-19271 - XP0051 - invalid atomic type definition
ORA-19271 - XP0051 - invalid atomic type definition

  • ora-19673 : error during proxy file string
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-30352 : inconsistent numeric precision or string length
  • ora-26725 : cannot downgrade apply handlers
  • ora-14150 : missing SUBPARTITION keyword
  • ora-32607 : invalid ITERATE value in MODEL clause
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-29400 : data cartridge error string
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-24325 : this OCI operation is not currently allowed
  • ora-01907 : TABLESPACE keyword expected
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-19512 : file search failed
  • ora-13292 : incorrect ARC_TOLERANCE specification
  • ora-15108 : missing or invalid template name
  • ora-14637 : cannot merge a subpartition with itself
  • ora-24754 : cannot start new transaction with an active transaction
  • ora-10360 : enable dbwr consistency checking
  • ora-25002 : cannot create INSTEAD OF triggers on tables
  • ora-01304 : subordinate process error. Check alert and trace logs
  • ora-30458 : 'string.string' cannot be refreshed because the refresh mask is string
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-07442 : function address must be in the range string to string
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-24370 : illegal piecewise operation attempted
  • ora-06403 : Unable to allocate memory.
  • ora-36977 : (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-03287 : invalid FREELIST GROUP specified
  • ora-19761 : block size string is not valid for change tracking file
  • 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.