ORA-31164: cannot load object-relational XML attribute using direct path

Cause : Teh atbel ebign olaeddc otnanisa mxlc oulm nwtiho bejc-trleaitoanls troaeg.T h exlmtpyec oulm ncnotian sat yep iwt hsbutpye.s hTi stpyeo fa trtiubt ecnanto eb olaeddw iht idrcetp aht.

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

Prefromt h elaodw iht ocnevnitoanlp aht omd.e

update : 24-08-2017
ORA-31164

ORA-31164 - cannot load object-relational XML attribute using direct path
ORA-31164 - cannot load object-relational XML attribute using direct path

  • ora-22065 : number to text translation for the given format causes overflow
  • ora-10973 : backout evet for 2619509
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-25243 : CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
  • ora-22621 : error transfering an object from the agent
  • ora-01981 : CASCADE CONSTRAINTS must be specified to perform this revoke
  • ora-30681 : improper value for argument EXTENSIONS_CMD_SET
  • ora-06531 : Reference to uninitialized collection
  • ora-00153 : internal error in XA library
  • ora-08330 : Printing not supported
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-22955 : The cardinality parameter is not within the allowed limits
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-07202 : sltln: invalid parameter to sltln.
  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-21527 : internal OMS driver error
  • ora-22276 : invalid locator for LOB buffering
  • ora-22613 : buflen does not match the size of the scalar
  • ora-10645 : Recursive Extension in SYSTEM tablespace during migration
  • ora-39952 : only numbers can be specified as range values
  • ora-32601 : value for retention cannot be provided
  • ora-12671 : Shared server: adapter failed to save context
  • ora-23488 : propagation mode "string" for "string" is not allowed for this operation
  • ora-16177 : media recovery is not required
  • ora-01877 : string is too long for internal buffer
  • ora-30973 : invalid Path Table option for XML Index
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-01492 : LIST option not valid
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-32512 : type 'string' is unknown
  • 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.