ORA-19045: character set id specified for XMLSerialize not valid

Cause : An XMLSerialize function was called with an invalid value for the caracter set id.

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

Modify the query so that the character set id is valid.

update : 26-09-2017

ORA-19045 - character set id specified for XMLSerialize not valid
ORA-19045 - character set id specified for XMLSerialize not valid

  • ora-07228 : rtecho: unable to restore terminal to echo mode.
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-00110 : invalid value string for attribute string, must be between string and string
  • ora-06951 : Operating system call error
  • ora-01227 : log string is inconsistent with other logs
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-16633 : the only instance of the database cannot be removed
  • ora-13381 : table:string not found in network:string
  • ora-01479 : last character in the buffer is not Null
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • ora-19506 : failed to create sequential file, name="string", parms="string"
  • ora-00314 : log string of thread string, expected sequence# string doesn't match string
  • ora-13530 : invalid TOPNSQL string, must be in the range (string, string)
  • ora-12157 : TNS:internal network communication error
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-31023 : Index size error
  • ora-02219 : invalid NEXT storage option value
  • ora-38798 : Cannot perform partial database recovery
  • ora-08106 : cannot create journal table string.string
  • ora-04081 : trigger 'string' already exists
  • ora-15164 : cluster rolling downgrade incomplete
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-28166 : duplicate rolename in list
  • ora-00267 : name of archived log file not needed
  • ora-07599 : spwat: $SCHDWK failure
  • ora-06127 : NETTCP: unable to change username
  • ora-07390 : sftopn: translate error, unable to translate file name.
  • 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.