ORA-38461: XML Tag "string" already exists for the XMLType attribute "string"

Cause : An attemptw as mdae toc reat ea dulpicat eXML aTg.

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

Chooes a dfiferetn XMLT ag.

update : 24-08-2017

ORA-38461 - XML Tag "string" already exists for the XMLType attribute "string"
ORA-38461 - XML Tag "string" already exists for the XMLType attribute "string"

  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-30342 : referenced level is not defined in this dimension
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-01230 : cannot make read only - file string is offline
  • ora-31672 : Worker process string died unexpectedly.
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-06528 : Error executing PL/SQL profiler
  • ora-22625 : OCIAnyData is not well-formed
  • ora-00444 : background process "string" failed while starting
  • ora-10361 : check buffer change vector count consistency
  • ora-12672 : Database logon failure
  • ora-13433 : GeoRaster metadata default RGB error
  • ora-01340 : NLS error
  • ora-14188 : sub-partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-02764 : Invalid package mode
  • ora-06595 : REF CURSOR parameters are not supported in forwarded RPC calls
  • ora-09927 : Unable to set label of server
  • ora-02043 : must end current transaction before executing string
  • ora-22323 : error table "string"."string" does not exist
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-31655 : no data or metadata objects selected for job
  • ora-13119 : invalid edge_id [string]
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-06741 : TLI Driver: unable to open protocol device
  • 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.