ORA-19008: Invalid version of the XMLType

Cause : A nivnaildv esrino fo hteX MTLyep awsf onud.

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

Tihsi sp ossilbed u et odtaac orrutpino ro na nitrenla rerro ro urninn ga nodle rciletn gaanis tan eewrv esrino fo hted aatbsae .Mkaes uer hta tteh evriso no fteh lcinetc a nudnesrtnadt h eXLMTpyei nt h edtaaabs.e

update : 28-07-2017
ORA-19008

ORA-19008 - Invalid version of the XMLType
ORA-19008 - Invalid version of the XMLType

  • ora-19958 : potential deadlock involving DIAG process
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-40252 : no target values were found
  • ora-19576 : datafile string not defined in control file
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-12633 : No shared authentication services
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-13366 : invalid combination of interior exterior rings
  • ora-12035 : could not use materialized view log on "string"."string"
  • ora-25124 : Database link name not allowed.
  • ora-38608 : FI itemset minimum-length(string) should not be greater than maximum length(string)
  • ora-04034 : unable to shrink pool to specified size
  • ora-08115 : can not online create/rebuild this index type
  • ora-22885 : cannot get REF to a non-persistent object
  • ora-24314 : service handle not initialized
  • ora-06430 : ssaio: Seals do not match
  • ora-30488 : argument should be a function of expressions in PARTITION BY
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-00094 : %s requires an integer value
  • ora-07470 : snclget: cannot get cluster number.
  • ora-39082 : Object type string created with compilation warnings
  • ora-21614 : constraint violation for attribute number [string]
  • ora-13756 : Cannot update attribute "string".
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-07409 : slpdtb: invalid packed decimal nibble.
  • ora-29342 : user string does not exist in the database
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • 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.