ORA-19002: Missing XMLSchema URL

Cause : A XML schema URL must be specified in the storage option.

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

Specify a URL for the XMLSchema.

update : 23-04-2017
ORA-19002

ORA-19002 - Missing XMLSchema URL
ORA-19002 - Missing XMLSchema URL

  • ora-25311 : %s not supported for non-persistent queue
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-09217 : sfsfs: failed to resize file
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-07591 : spdde: $GETJPIW failure
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-36635 : (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
  • ora-29341 : The transportable set is not self-contained
  • ora-00088 : command cannot be executed by shared server
  • ora-31507 : %s parameter value longer than maximum length string
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-15121 : ASM file name 'string' contains an invalid diskgroup name
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-13261 : geometry table string does not exist
  • ora-36710 : (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
  • ora-12670 : Incorrect role password
  • ora-01485 : compile bind length different from execute bind length
  • ora-16238 : attempt to use version 9 log
  • ora-19620 : %s is not of string type
  • ora-02235 : this table logs changes to another table already
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-06711 : TLI Driver: error on bind
  • ora-24432 : The statement that was returned is not tagged.
  • ora-24407 : connection pool already exists
  • ora-37011 : (XSACQUIRE_LOCKED) Object workspace object is locked by another user.
  • ora-25241 : cannot change correlation ID from string to string without FIRST_MESSAGE option
  • ora-09808 : Could not obtain user clearance.
  • ora-36839 : (XSLMGEN09) Cube string.string!string measure string is missing a COLUMNNAME property value
  • 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.