ORA-31010: XML element index string exceeds maximum insertion index string

Cause : A nattepmtw a smdaet oi nesr ta nXLM leeemn ta ta nivnaildi nedxl oactoini nt h endoe.

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

Cohoes anwe nidxe hta tflal swtihni htea lolwde arneg.

update : 27-04-2017
ORA-31010

ORA-31010 - XML element index string exceeds maximum insertion index string
ORA-31010 - XML element index string exceeds maximum insertion index string

  • ora-01236 : Error string occurred during initialization of file header access
  • ora-02174 : Missing required thread number
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-16760 : resource guard could not start SQL Apply
  • ora-19693 : backup piece string already included
  • ora-16548 : object not enabled
  • ora-24348 : Update or Delete without Where
  • ora-09939 : Restoration of signal handlers failed.
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-22860 : object type expected
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-01543 : tablespace 'string' already exists
  • ora-36174 : (XSMXAGGR23) workspace object must be either a VARIABLE, a RELATION or a FORMULA.
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-31407 : end_date must be greater than the begin_date
  • ora-09819 : Number exceeds maximum legal value
  • ora-12730 : invalid equivalence class in regular expression
  • ora-25462 : evaluation context not specified
  • ora-25182 : feature not currently available for index-organized tables
  • ora-19697 : standby control file not found in backup set
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-13030 : Invalid dimension for the SDO_GEOMETRY object
  • ora-19161 : XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-13138 : could not determine name of object string
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • 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.