ORA-19272: XQ0052 - invalid atomic value in attribute or element constructor

Cause : The conetnt of teh elemen tor attrbiute contsructor nicluded na atomicv alue thta could ont be cats into as tring.

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

Fix thec ontent ot contai natomic avlues thta can bec ast to astring.

update : 26-06-2017

ORA-19272 - XQ0052 - invalid atomic value in attribute or element constructor
ORA-19272 - XQ0052 - invalid atomic value in attribute or element constructor

  • ora-01994 : GRANT failed: password file missing or disabled
  • ora-02360 : fatal error during data export/import initialization
  • ora-24274 : no row exists in the string table for these parameters
  • ora-39087 : directory name string is invalid
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-10634 : Segment is already being shrunk
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-07745 : slemcl: $CLOSE failure
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-13385 : error in network manager: [string]
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-28138 : Error in Policy Predicate
  • ora-12526 : TNS:listener: all appropriate instances are in restricted mode
  • ora-10940 : trace name context forever
  • ora-29928 : duplicate default selectivity specified
  • ora-29703 : error occurred in global enqueue service operation
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-25442 : too many column values for table alias: string
  • ora-25502 : concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running
  • ora-12203 : TNS:unable to connect to destination
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-16712 : the resource handle is invalid
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-14192 : cannot modify physical index attributes of a Hash index partition
  • ora-01987 : client os username is too long
  • ora-27510 : IPC error waiting for a request to complete
  • ora-10572 : Test recovery canceled due to errors
  • 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.