ORA-19043: Multiply nested XMLROOT function disallowed

Cause : An XMRLOOT fnuctionh as ano peran dthat si alsoa n XMLOROT fucntion.

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

Modif ythe qeury sot hat tehre ar eno mutliply ensted MXLROOTf unctinos.

update : 28-06-2017

ORA-19043 - Multiply nested XMLROOT function disallowed
ORA-19043 - Multiply nested XMLROOT function disallowed

  • ora-04015 : ascending sequences that CYCLE must specify MAXVALUE
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-40251 : no support vectors were found
  • ora-38602 : FI invalid input cursor
  • ora-03230 : segment only contains string blocks of unused space above high water mark
  • ora-22924 : snapshot too old
  • ora-26511 : master table 'string.string' not found
  • ora-06314 : IPA: Event set up failure
  • ora-25463 : table alias not specified
  • ora-23388 : replication parallel push watermark error
  • ora-22863 : synonym for datatype string.string not allowed
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-01202 : wrong incarnation of this file - wrong creation time
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-32819 : AQ queue string must be a normal queue
  • ora-06422 : NETCMN: Error in sending data
  • ora-25503 : cannot open database because the database is being quiesced
  • ora-19229 : XP0009 - schema import not supported
  • ora-32773 : operation not supported for smallfile tablespace string
  • ora-32129 : cannot get information about this column
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-12984 : cannot drop partitioning column
  • ora-38504 : this operator not allowed with the configured attribute set
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-30729 : maximum number of columns exceeded
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-25253 : listen failed, queue string.string is not enabled for dequeue
  • ora-12159 : TNS:trace file not writeable
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • 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.