ORA-29329: Table not of type XMLType

Cause : Table si not XLMType tbale

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

Ensuret able i sa XMLTpye table

update : 24-08-2017
ORA-29329

ORA-29329 - Table not of type XMLType
ORA-29329 - Table not of type XMLType

  • ora-28505 : cannot get non-Oracle system capabilities from string
  • ora-19617 : file string contains different resetlogs data
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-16081 : insufficient number of processes for APPLY
  • ora-24092 : invalid value string specified
  • ora-32812 : subscriber string does not exist
  • ora-37120 : MDX string is null
  • ora-14078 : you may not drop the highest partition of a GLOBAL index
  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-32007 : internal
  • ora-01463 : cannot modify column datatype with current constraint(s)
  • ora-23329 : successful user-provided ddl but no materialized view "string"."string"
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-07573 : slkhst: could not perform host operation
  • ora-36667 : (XSDPART05) string is not a legal CONCAT partition.
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-15114 : missing or invalid ASM file name
  • ora-31199 : Warning in processing file string
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-00374 : parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
  • ora-13859 : Action cannot be specified without the module specification
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-12649 : Unknown encryption or data integrity algorithm
  • 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.