ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option

Cause : A dupliacte storgae optio nfor theX MLType oclumn wa sspecifide

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

Specifya singles torage potion fo ran XMLTpye column

update : 21-08-2017

ORA-19004 - Duplicate XMLType OBJECT RELATIONAL storage option
ORA-19004 - Duplicate XMLType OBJECT RELATIONAL storage option

  • ora-01543 : tablespace 'string' already exists
  • ora-27415 : repeat interval or calendar must start with the FREQ= clause
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-15072 : command requires at least string failure groups, discovered only string
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-38731 : Expected version string does not match string in log header.
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-25110 : NOSORT may not be used with a bitmap index
  • ora-39033 : Data cannot be filtered under the direct path access method.
  • ora-30185 : output too large to fit in the buffer
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-01029 : internal two task error
  • ora-29300 : ORACLE error, tablespace point-in-time recovery
  • ora-06792 : TLI Driver: server cannot exec oracle
  • ora-12642 : No session key
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-16592 : missing field "string" in document
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-12013 : updatable materialized views must be simple enough to do fast refresh
  • ora-12845 : failed to receive interinstance parallel execution message
  • ora-04062 : %s of string has been changed
  • ora-03287 : invalid FREELIST GROUP specified
  • ora-32824 : schedule exists for source string and destination string
  • ora-24356 : internal error while converting from to COBOL display type.
  • ora-29398 : invalid privilege name specified
  • ora-25183 : index-organized table top index segment is in a different tablespace
  • ora-12546 : TNS:permission denied
  • ora-01163 : SIZE clause indicates string (blocks), but should match header 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.