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-06-2017

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

  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-19601 : output file is string string (string)
  • ora-01555 : snapshot too old: rollback segment number string with name "string" too small
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-04097 : DDL conflict while trying to drop or alter a trigger
  • ora-25327 : Array size is invalid
  • ora-24191 : the property name string has existed
  • ora-16527 : unable to allocate SGA heap
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-28026 : user with same external name already exists
  • ora-31515 : CDC change source string already exists
  • ora-19860 : piece validation cannot be performed more than once
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-16061 : Log file status has changed
  • ora-22970 : name does not correspond to an object view
  • ora-06813 : TLI Driver: the configured ethernet address is incorrect
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-27029 : skgfrtrv: sbtrestore returned error
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-29913 : error in executing string callout
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-19109 : RETURNING keyword expected
  • ora-32337 : cannot alter materialized view with pending changes refresh on commit
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-00018 : maximum number of sessions exceeded
  • ora-12826 : hung parallel query server was killed
  • ora-07753 : slemcf: fseek before write failure
  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • 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.