ORA-22918: specified column or attribute is not a VARRAY type

Cause : Attemp to define a VARRAY storage clause for a column or attribute which is not VARRAY type.

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

Specify VARRAY storage clause for a VARRAY column or attribute.

update : 25-09-2017

ORA-22918 - specified column or attribute is not a VARRAY type
ORA-22918 - specified column or attribute is not a VARRAY type

  • ora-23612 : unable to find tablespace "string"
  • ora-13766 : A ranking measure is required.
  • ora-34164 : (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
  • ora-09924 : Can't spawn process - core dump directory not created properly
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-15008 : cannot drop system template
  • ora-14305 : List value 'string' specified twice in partition 'string'
  • ora-12439 : invalid combination of policy options
  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-31422 : owner schema string does not exist
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-03249 : Uniform size for auto segment space managed tablespace should have atleast string blocks
  • ora-33060 : (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
  • ora-19649 : offline-range record recid string stamp string not found in file string
  • ora-31092 : invalid SQL name "string"
  • ora-31057 : Display Name of the element being inserted is null
  • ora-16504 : the Data Guard configuration already exists
  • ora-31692 : The following SQL statement failed trying to insert a row into the Master table: string
  • ora-16592 : missing field "string" in document
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-16585 : illegal operation on a primary site
  • ora-21611 : key length [string] is invalid
  • ora-00266 : name of archived log file needed
  • ora-27478 : job "string.string" is running
  • ora-29663 : Unable to find a method that matches one or more of the functions
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-39134 : Cannot include "string" tablespace as a Transportable Tablespace
  • ora-01150 : cannot prevent writes - file string has online backup set
  • 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.