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 : 22-09-2017

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

  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-38788 : More standby database recovery is needed
  • ora-00062 : DML full-table lock cannot be acquired; DML_LOCKS is 0
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-06010 : NETASY: dialogue file too long
  • ora-24391 : invalid fetch operation
  • ora-06422 : NETCMN: Error in sending data
  • ora-09341 : scumnt: unable to mount database
  • ora-00000 : normal, successful completion
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-23316 : the masterdef is string
  • ora-19809 : limit exceeded for recovery files
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-06766 : TLI Driver: close failed during release
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-24403 : error occured while trying to destroy the connection pool
  • ora-36378 : (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
  • ora-16522 : generic template not found
  • ora-16214 : apply stalled for apply delay
  • ora-00017 : session requested to set trace event
  • ora-28270 : Malformed user nickname for password authenticated global user.
  • ora-31688 : Worker process string failed during startup.
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-12100 : materialized view log on "string"."string" already has sequence
  • ora-39780 : Direct path context operations are not allowed after the context is aborted or finished
  • ora-27058 : file I/O question parameter is invalid
  • ora-30746 : error occured while trying to drop column "string" in table "string"
  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • 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.