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-06-2017

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

  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-25425 : connection lost during rollback
  • ora-02200 : WITH GRANT OPTION not allowed for PUBLIC
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-22314 : method information mismatch in ALTER TYPE
  • ora-09977 : skxfqhini: Error Connecting
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-02070 : database stringstring does not support string in this context
  • ora-30516 : database role change triggers cannot have BEFORE type
  • ora-15132 : block string of file string in diskgroup string could not be written
  • ora-26530 : unable to build materialized view refresh control list
  • ora-01278 : error creating file 'string'
  • ora-16778 : redo transport error for one or more databases
  • ora-13766 : A ranking measure is required.
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-02846 : Unkillable server
  • ora-02463 : Duplicate HASH IS option specified
  • ora-38452 : Expression Filter index name may not be longer than 25 characters
  • ora-12724 : regular expression corrupt
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-31689 : illegal value for base worker id, string
  • ora-13825 : missing SQL statement text for create SQL profile
  • ora-02149 : Specified partition does not exist
  • ora-31232 : DBMS_LDAP: invalid MOD_PROPERTY_SET
  • ora-14602 : SUBPARTITION TEMPLATE is legal only for a composite partitioned table
  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-28363 : buffer provided not large enough for output
  • 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.