ORA-19000: missing RELATIONAL keyword

Cause : The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification.

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

Supply the RELATIONAL keyword in the storage clause

update : 27-05-2017

ORA-19000 - missing RELATIONAL keyword
ORA-19000 - missing RELATIONAL keyword

  • ora-39312 : call to DBMS_SCHEMA_COPY.CLEAN_TARGET is not legal
  • ora-38505 : invalid default value for the attribute
  • ora-18008 : cannot find OUTLN schema
  • ora-06917 : CMX: error in data read (too many bytes read)
  • ora-31498 : description and remove_description cannot both be specified
  • ora-07204 : sltln: name translation failed due to lack of output buffer space.
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-14296 : Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-12913 : Cannot create dictionary managed tablespace
  • ora-14402 : updating partition key column would cause a partition change
  • ora-32020 : SID=* clause needed to modify this parameter
  • ora-00131 : network protocol does not support registration 'string'
  • ora-12098 : cannot comment on the materialized view
  • ora-14014 : maximum number of partitioning columns is 16
  • ora-27480 : window "string" is currently open
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-06512 : at stringline string
  • ora-01946 : DEFAULT TABLESPACE already specified
  • ora-25448 : rule string.string has errors
  • ora-29800 : invalid name for operator
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-12714 : invalid national character set specified
  • ora-24064 : propagation for QUEUE string and DESTINATION string already enabled
  • ora-12225 : TNS:destination host unreachable
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-06722 : TLI Driver: connection setup failure
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-25436 : invalid table alias: string
  • 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.