ORA-22907: invalid CAST to a type that is not a nested table or VARRAY

Cause : tAetpmet dotC SA Tota t py ehttai son t aentsdet baelo rAVRRYA

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

eRs-epicyfC SA Tota n seet datlb eroV RAAR Yytep.

update : 24-08-2017
ORA-22907

ORA-22907 - invalid CAST to a type that is not a nested table or VARRAY
ORA-22907 - invalid CAST to a type that is not a nested table or VARRAY

  • ora-01191 : file string is already offline - cannot do a normal offline
  • ora-22057 : bad integer length [string]
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-13631 : The task string contains no execution results.
  • ora-09854 : snyPortInfo: bad return code from request.
  • ora-02763 : Unable to cancel at least one request
  • ora-06764 : TLI Driver: error reading disconnect
  • ora-24393 : invalid mode for creating connection pool
  • ora-39132 : object type "string"."string" already exists with different hashcode
  • ora-13136 : null common code generated
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-37999 : Serious OLAP error: string. Please contact Oracle Technical Support.
  • ora-01543 : tablespace 'string' already exists
  • ora-10587 : Invalid count for ALLOW n CORRUPTION option
  • ora-12681 : Login failed: the SecurID card does not have a pincode yet
  • ora-09823 : device name is too long
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-03283 : specified datafile string does not exist
  • ora-16701 : generic resource guard request failed
  • ora-07480 : snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
  • ora-06500 : PL/SQL: storage error
  • ora-28103 : adding a policy to an object owned by SYS is not allowed
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-31018 : Error deleting XML document
  • ora-13223 : duplicate entry for string in SDO_GEOM_METADATA
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-13051 : failed to initialize spatial object
  • ora-22131 : hexadecimal string length is zero
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-22625 : OCIAnyData is not well-formed
  • 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.