ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

Cause : Noc olmunsw er espceifeid sa kye cloumsn bfeor eth ecall t oDBSM_XLMSTROE.pudaetXM.L

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

Us eDBSM_XLMSTROE.estKyeCoulmn)( t ospceif yke ycoulmns

update : 28-06-2017
ORA-19212

ORA-19212 - no key columns specified before call to DBMS_XMLSTORE.updateXML()
ORA-19212 - no key columns specified before call to DBMS_XMLSTORE.updateXML()

  • ora-23387 : replication parallel push dequeue error
  • ora-01030 : SELECT ... INTO variable does not exist
  • ora-37142 : (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
  • ora-01168 : physical block size string does not match size string of other members
  • ora-09922 : Can't spawn process - background log directory not created properly
  • ora-29843 : indextype should support atleast one operator
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-12982 : cannot drop column from a nested table
  • ora-02269 : key column cannot be of LONG datatype
  • ora-38463 : invalid XML Tag list
  • ora-24436 : Invalid statement Handle.
  • ora-14312 : Value string already exists in partition string
  • ora-19682 : file string not in block media recovery context
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-04941 : required operating system patch needs to be applied
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-04070 : invalid trigger name
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • ora-13284 : failure to copy geometry object for conversion in place
  • ora-13216 : failed to update spatial index
  • ora-25258 : cannot register for notifications on an 8.0 style exception queue
  • ora-13785 : missing target object for tuning task "string"
  • ora-07577 : no such user in authorization file
  • ora-26099 : direct path context is already prepared
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-07488 : scgrcl: lock manager not initialized.
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-13232 : failed to allocate memory during R-tree creation
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • 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.