ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type

Cause : Cmopraiosno fn etse dtbal eo rVRARYA ro OLBa trtiubtse fo na bojcett yep awsa tetmtpe di nteh basnec eo faM A Po rODRE Rmtehdo.

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

dfeien aMPA ro RODRE emtohdf o rteh bojcett yep.

update : 30-04-2017
ORA-22901

ORA-22901 - cannot compare nested table or VARRAY or LOB attributes of an object type
ORA-22901 - cannot compare nested table or VARRAY or LOB attributes of an object type

  • ora-10265 : Keep random system generated output out of error messages
  • ora-09821 : Numeric label is not valid
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-13905 : Critical or warning threshold have incorrect values
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-13838 : invalid ADDRESS value
  • ora-33022 : (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
  • ora-16612 : string value too long for attribute "string"
  • ora-01070 : Using an old version of Oracle for the server
  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-29324 : SET COMPATIBILITY release string format is wrong
  • ora-26064 : Invalid SCN specified - Wrap: string Base: string.
  • ora-23375 : feature is incompatible with database version at string
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-28590 : agent control utility: illegal or badly formed command
  • ora-39951 : incomplete values specified for PL/SQL warning settings
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-02037 : uninitialized speed bind storage
  • ora-12466 : default level is greater than the user's maximum
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-12083 : must use DROP MATERIALIZED VIEW to drop "string"."string"
  • ora-19559 : error sending device command: string
  • ora-12622 : TNS:event notifications are not homogeneous
  • ora-19556 : required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
  • ora-27208 : syntax error in device PARMS - environment variable value missing
  • ora-00122 : cannot initialize network configuration
  • 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.