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 : 21-08-2017

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

  • ora-29278 : SMTP transient error: string
  • ora-37174 : source SQL must be a SELECT statement
  • ora-02463 : Duplicate HASH IS option specified
  • ora-31639 : unexpected data found
  • ora-06745 : TLI Driver: listener already running
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-09272 : remote os logon is not allowed
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-17509 : Attempt to do i/o beyond block1 offset
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-19242 : XQ0022 - namespace declaration attribute must be a literal
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-16767 : SQL Apply unexpectedly online
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-23432 : master site string already exists
  • ora-25306 : Cannot connect to buffered queue's owner instance
  • ora-24314 : service handle not initialized
  • ora-23444 : duplicate template parameter
  • ora-07404 : sfareq: Timeout occurred waiting for request to complete.
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-13702 : Snapshot IDs specified by the range [string, string] are equal.
  • 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.