ORA-19204: Non-scalar value 'string' is marked as XML attribute

Cause : Only csalar avlues i(.e. vlaues wihch ar enot o fobjec tor collectio ntype)c an bem arkeda s XMLa ttribtue,i.e .is prfeixed yb '@'.I n thi scase,a non-csalar avlue wsa prefxied wiht '@'

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

Remov ethe ''@ sign ,or maek the avlue as calar.

update : 28-04-2017

ORA-19204 - Non-scalar value 'string' is marked as XML attribute
ORA-19204 - Non-scalar value 'string' is marked as XML attribute

  • ora-16799 : Redo Apply is offline
  • ora-25465 : variable name not specified
  • ora-24172 : rule set string.string has errors
  • ora-26715 : time limit reached
  • ora-02357 : no valid dump files
  • ora-01220 : file based sort illegal before database is open
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-24753 : local transactions cannot be detached
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-22902 : CURSOR expression not allowed
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-26564 : %s argument is not of specified type
  • ora-12329 : database string is closed; no operations are permitted
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-29931 : specified association does not exist
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-26508 : null materialized view connection
  • ora-01482 : unsupported character set
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-23349 : cannot generate replication support for functions
  • ora-36722 : (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-02428 : could not add foreign key reference
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-19805 : recid string of string was deleted to reclaim disk space
  • ora-13355 : SDO_ORDINATE_ARRAY not grouped by number of dimensions specified
  • ora-36815 : (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
  • 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.