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 : 25-04-2017

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

  • ora-00221 : error on write to control file
  • ora-07580 : spstp: $GETJPIW failure
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-02710 : osnpop: fork failed
  • ora-14168 : only one subpartition may be modified
  • ora-38707 : Media recovery is not enabled.
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-16778 : redo transport error for one or more databases
  • ora-28183 : proper authentication not provided by proxy
  • ora-39155 : error expanding dump file name "string"
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-30363 : columns in a dimension column list must be in the same relation
  • ora-23465 : flavor already includes column string of "string"."string"
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-07623 : smscre: $CRMPSC failure
  • ora-01489 : result of string concatenation is too long
  • ora-02322 : failure in accessing storage table of the nested table column
  • ora-34348 : (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
  • ora-28561 : unable to set date format on non-Oracle system
  • ora-25962 : join index prevents multitable insert or merge
  • ora-16073 : archiving must be enabled
  • ora-02272 : constrained column cannot be of LONG datatype
  • ora-01890 : NLS error detected
  • ora-28035 : Cannot Get Session Key for Authentication
  • ora-22929 : invalid or missing directory name
  • ora-26718 : transaction limit reached
  • ora-38901 : column "string" of table "string" must be one of the first "number" columns
  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-02726 : osnpop: access error on oracle executable
  • ora-27460 : cannot execute disabled job "string.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.