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 : 28-05-2017

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

  • ora-23463 : flavor incompatible with object "string"."string"
  • ora-12566 : TNS:protocol error
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-30936 : Maximum number (string) of 'string' XML node elements exceeded
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-23312 : not the masterdef according to string
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-13388 : invalid value for dst_spec parameter
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-27069 : attempt to do I/O beyond the range of the file
  • ora-12219 : TNS:missing community name from address in ADDRESS_LIST
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-19116 : too many xmlspace declarations
  • ora-29833 : indextype does not exist
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-00274 : illegal recovery option string
  • ora-15031 : disk specification 'string' matches no disks
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-22852 : invalid PCTVERSION LOB storage option value
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-10568 : Failed to allocate recovery state object: out of SGA memory
  • ora-32733 : Error occurred when executing Parallel Oradebug
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-01257 : cannot reuse database file string, unknown file size
  • ora-23292 : The constraint does not exist
  • ora-09280 : sllfcf: error closing file
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-29348 : You must specify the datafiles to be plugged in
  • ora-24182 : attribute number specified does not exist
  • 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.