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 : 28-04-2017
ORA-29329

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

  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-24812 : character set conversion to or from UCS2 failed
  • ora-30345 : circular dimension hierarchy
  • ora-01626 : rollback segment number 'string' cannot handle more transactions
  • ora-21601 : attribute is not an object
  • ora-06757 : TLI Driver: server got bad command
  • ora-39165 : Schema string was not found.
  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-13617 : The specified task string already executing
  • ora-16754 : resource guard could not activate standby database
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-01073 : fatal connection error: unrecognized call type
  • ora-22860 : object type expected
  • ora-29507 : query derived from USING clause found zero or many rows
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-09217 : sfsfs: failed to resize file
  • ora-00029 : session is not a user session
  • ora-13800 : concurrent DDL failure on SQL repository objects
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-06703 : TLI Driver: send break message failed
  • ora-13780 : SQL statement does not exist.
  • ora-27545 : Fail to prepare buffer for remote update
  • ora-16623 : stale DRC UID sequence number detected
  • ora-24087 : Invalid database user string
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • 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.