ORA-22931: MOVE of nested table to a different tablespace not supported

ORA-22931: MOVE of nested table to a different tablespace not supported

Cause: Attempt to move a nested table to a different tablespace.

Action: Nested tables always colocate in the same tablespace as the parent. A nested table can be moved to a different tablespace only by moving its containing table to the target tablespace.

ORA-22930: directory does not exist

ORA-22930: directory does not exist

Cause: Attempt to access a directory that does not exist.

Action: Make sure the name is correct.

ORA-22929: invalid or missing directory name

ORA-22929: invalid or missing directory name

Cause: The required directory name is invalid or missing.

Action: Specify a valid name.

ORA-22928: invalid privilege on directories

ORA-22928: invalid privilege on directories

Cause: An attempt was made to grant or revoke an invalid privilege on a directory.

Action: Only CREATE, DELETE, READ and WRITE privileges can be granted or revoked on directories. Do not grant or revoke other privileges.

ORA-22927: invalid LOB locator specified

ORA-22927: invalid LOB locator specified

Cause: There are several causes: (1) the LOB locator was never initialized; (2) the locator is for a BFILE and the routine expects a BLOB or CLOB or NCLOB locator; (3) the locator is for a BLOB or CLOB or NCLOB and the routine expects a BFILE locator; (4) trying to update the LOB in a trigger body --LOBs in trigger bodies are read only.

Action: For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2) and (3), pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.

ORA-22926: specified trim length is greater than current LOB value s length

ORA-22926: specified trim length is greater than current LOB value s length

Cause: The input length for which to trim the LOB value to is greater than the current length of the LOB value.

Action: May not need to trim the LOB value because it s already smaller than the trim length specified. Or, if trimming the LOB value really is required, use a smaller trim length.

ORA-22925: operation would exceed maximum size allowed for a LOB value

ORA-22925: operation would exceed maximum size allowed for a LOB value

Cause: Trying to write too much data to the LOB value. LOB size is limited to 4 gigabytes.

Action: Either start writing at a smaller LOB offset or write less data to the LOB value.

ORA-22924: snapshot too old

ORA-22924: snapshot too old

Cause: The version of the LOB value needed for the consistent read was already overwritten by another writer.

Action: Use a larger version pool.

ORA-22923: amount of data specified in streaming LOB write is 0

ORA-22923: amount of data specified in streaming LOB write is 0

Cause: Trying to write LOB value via the streaming mechanism (i.e. unlimited write) but the input amount of data to stream was specified as 0. Thus, the user is trying to write 0 bytes to the LOB value.

Action: Write more than 0 bytes to the LOB value.

ORA-22922: nonexistent LOB value

ORA-22922: nonexistent LOB value

Cause: The LOB value associated with the input locator does not exist. The information in the locator does not refer to an existing LOB.

Action: Repopulate the locator by issuing a select statement and retry the operation.

ORA-22921: length of input buffer is smaller than amount requested

ORA-22921: length of input buffer is smaller than amount requested

Cause: The buffer length is not big enough to hold the amount of data requested.

Action: Verify that the number of bytes or characters specified in the input amount parameter is not bigger than the number of bytes specified in the input buffer length parameter. Allocate more space for the input buffer if necessary.

ORA-22920: row containing the LOB value is not locked

ORA-22920: row containing the LOB value is not locked

Cause: The row containing the LOB value must be locked before updating the LOB value.

Action: Lock the row containing the LOB value before updating the LOB value.

ORA-22919: dangling REF error or lock object failed for no wait request

ORA-22919: dangling REF error or lock object failed for no wait request

Cause: The error could be one of the following. The object corresponding to the REF does not exist or the object was locked by another user and the lock with nowait request failed.

Action: Ensure that the REF value is pointing to an existing object or issue a lock request without the nowait option.

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

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: Specify VARRAY storage clause for a VARRAY column or attribute.

ORA-22917: use VARRAY to define the storage clause for this column or attribute

ORA-22917: use VARRAY to define the storage clause for this column or attribute

Cause: Not using VARRAY to define storage clause for VARRAY column or attribute.

Action: Specify VARRAY before the column storage clause and resubmit statement.

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

Cause: Exact FETCH on a query was specified which is not allowed if the query returns any cursors.

Action: Do not use an exact FETCH.

ORA-22915: cannot ALTER a nested table s storage table to ADD or MODIFY columns

ORA-22915: cannot ALTER a nested table s storage table to ADD or MODIFY columns

Cause: any such change.

Action: Columns cannot be added or modified for a nested table s storage table. You must alter the parent table s nested table column to

ORA-22914: DROP of nested tables not supported

ORA-22914: DROP of nested tables not supported

Cause: Attempted to DROP a nested table.

Action: nested tables cannot be explicitly dropped. nested tables can only be dropped by dropping their containing parent table.

ORA-22913: must specify table name for nested table column or attribute

ORA-22913: must specify table name for nested table column or attribute

Cause: The storage clause is not specified for a nested table column or attribute.

Action: Specify the nested table storage clause for the nested table column or attribute.

ORA-22912: specified column or attribute is not a nested table type

ORA-22912: specified column or attribute is not a nested table type

Cause: The storage clause is specified for a column or attribute that is not a nested table column or attribute.

Action: Specify a valid nested table column or attribute.

ORA-22911: duplicate storage specification for the nested table item

ORA-22911: duplicate storage specification for the nested table item

Cause: The storage clause is specified more than once for the NESTED TABLE column.

Action: Remove the duplicate storage specification.

ORA-22910: cannot specify schema name for nested tables

ORA-22910: cannot specify schema name for nested tables

Cause: Table name was qualified with schema name in the nested table column s (or attribute s) storage clause.

Action: Re-specify the nested table item s storage clause without the schema name qualification. By default, the storage table for the nested table item is created in the same schema as the containing table.

ORA-22909: exceeded maximum VARRAY limit

ORA-22909: exceeded maximum VARRAY limit

Cause: The total number of elements used in VARRAY construction exceeds the specified VARRAY limit.

Action: Don t use the more than the specified limit of elements for VARRAY construction.

ORA-22908: reference to NULL table value

ORA-22908: reference to NULL table value

Cause: The evaluation of the THE subquery or nested table column resulted in a NULL value implying a NULL table instance. The THE subquery or nested table column must identify a single non-NULL table instance.

Action: Ensure that the evaluation of the THE subquery or nested table column results in a single non-null table instance. If happening in the context of an insert statement where the THE subquery is the target of an insert, then ensure that an empty nested table instance is created by updating the nested table column of the parent table s row specifying an empty nested table constructor.

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

Cause: Attempted to CAST to a type that is not a nested table or VARRAY

Action: Re-specify CAST to a nested table or VARRAY type.

ORA-22906: cannot perform DML on expression or on nested table view column

ORA-22906: cannot perform DML on expression or on nested table view column

Cause: Attempted to perform a DML on an expression or on a nested table view column where a nested table column of a base table is expected.

Action: Only nested table column of a base table is allowed in the DML.

ORA-22905: cannot access rows from a non-nested table item

ORA-22905: cannot access rows from a non-nested table item

Cause: attempt to access rows of an item whose type is not known at parse time or that is not of a nested table type

Action: use CAST to cast the item to a nested table type

ORA-22904: invalid reference to a nested table column

ORA-22904: invalid reference to a nested table column

Cause: invalid use of a nested table column

Action: remove invalid reference to the nested table column

ORA-22903: MULTISET expression not allowed

ORA-22903: MULTISET expression not allowed

Cause: MULTISET expressions are allowed only inside a CAST to a nested table or VARRAY type.

Action: put the MULTISET(subquery) expression inside a CAST to a nested table or VARRAY type.

ORA-22902: CURSOR expression not allowed

ORA-22902: CURSOR expression not allowed

Cause: CURSOR on a subquery is allowed only in the top-level SELECT list of a query.

Action: none

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

Cause: Comparison of nested table or VARRAY or LOB attributes of an object type was attempted in the absence of a MAP or ORDER method.

Action: define a MAP or ORDER method for the object type.

ORA-22900: the SELECT list item of THE subquery is not a collection type

ORA-22900: the SELECT list item of THE subquery is not a collection type

Cause: The THE subquery must SELECT a nested table or VARRAY item.

Action: change the subquery to SELECT a nested table or VARRAY item.

ORA-22899: cannot specify both scope and rowid constraint on ref column

ORA-22899: cannot specify both scope and rowid constraint on ref column

Cause: An attempt was made to specify both a scope and a rowid constraint on a REF column.

Action: Remove either the rowid or scope constraint and then retry the operation.

ORA-22898: existing scope clause on string points to a table other than the one mentioned in the referential constraint

ORA-22898: existing scope clause on string points to a table other than the one mentioned in the referential constraint

Cause: Table mentioned in the referential integrity constraint is different from the scope table of the REF column.

Action: Specify the scope table of the REF column in the referential integrity constraint and then retry the operation.

ORA-22897: no scope clause specified for user-defined REF column string

ORA-22897: no scope clause specified for user-defined REF column string

Cause: User-defined REF column does not have a scope constraint.

Action: Specify a scope constraint for the user-defined REF column and retry the operation.

ORA-22896: cannot have both scope and referential constraint on REF column string

ORA-22896: cannot have both scope and referential constraint on REF column string

Cause: REF column has both a referential and a scope constraint. A referential constraint implies a scope constraint.

Action: Remove either the referential or scope constraint and then retry the operation.

ORA-22895: referenced table string in schema string is not an object table

ORA-22895: referenced table string in schema string is not an object table

Cause: The referenced table specified for a REF column is not an object table.

Action: Ensure that the referenced table is an object table.Then retry the operation.

ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

Cause: An attempt was made to add a constraint to existing unscoped REF columns of a table which contains one or more rows.

Action: Remove the constraint specification or add the constraint after emptying the table.

ORA-22893: constraint can be specified only for REF columns

ORA-22893: constraint can be specified only for REF columns

Cause: The constraint specified does not apply to non-REF columns.

Action: Remove the constraint and retry the operation.

ORA-22892: scoped table string does not exist in schema string

ORA-22892: scoped table string does not exist in schema string

Cause: The scoped table specified for a REF column does not exist.

Action: Ensure that the scoped table exists and retry the operation.

ORA-22891: cannot have multiple columns in REF constraint

ORA-22891: cannot have multiple columns in REF constraint

Cause: An attempt was made to specify multiple columns in a single REF constraint.

Action: Specify separate constraints for each column and retry the operation.

ORA-22890: cannot specify name for REF column constraint

ORA-22890: cannot specify name for REF column constraint

Cause: An attempt was made to specify a constraint name for a constraint on a REF column.

Action: Remove the constraint name and retry the operation.

ORA-22889: REF value does not point to scoped table

ORA-22889: REF value does not point to scoped table

Cause: An attempt was made to insert a REF value that does not point to the scoped table.

Action: Ensure that the REF values point to the scoped table.

ORA-22888: duplicate SCOPE clauses for a REF column

ORA-22888: duplicate SCOPE clauses for a REF column

Cause: Multiple SCOPE clauses were specified for a single REF column.

Action: Remove the duplicate SCOPE clauses and retry the operation.

ORA-22887: type of REF column is not the same as that of its scoped table

ORA-22887: type of REF column is not the same as that of its scoped table

Cause: The type specified for the REF column and the type specified for the scope table are different.

Action: Ensure that the types of a REF column and its scoped table are the same.

ORA-22886: scoped table string in schema string is not an object table

ORA-22886: scoped table string in schema string is not an object table

Cause: The scoped table specified for a REF column is not an object table.

Action: Ensure that the scoped table is an object table.Then retry the operation.

ORA-22885: cannot get REF to a non-persistent object

ORA-22885: cannot get REF to a non-persistent object

Cause: An attempt was made to get a REF for something other than an object in an object table. REFs can only be taken for objects in object tables.

Action: Rewrite the query to obtain REF values from object tables.

ORA-22884: object modification failed

ORA-22884: object modification failed

Cause: The object could not be modified in the database.

Action: Check to see if the object table exists and the object size is not too big. Then retry the operation.

ORA-22883: object deletion failed

ORA-22883: object deletion failed

Cause: The object could not be deleted from the database.

Action: Check to see if the object table exists.Then retry the operation.

ORA-22882: object creation failed

ORA-22882: object creation failed

Cause: The object cannot be created in the database.

Action: Check to see if the object table exists and the object size is not too big. Then retry the operation.

ORA-22881: dangling REF

ORA-22881: dangling REF

Cause: The object corresponding to the REF that was accessed does not exist.

Action: Ensure that the REF value is pointing to an existing object.

ORA-22880: invalid REF

ORA-22880: invalid REF

Cause: An invalid REF was accessed.

Action: Modify the REF and retry the operation.

ORA-22879: cannot use the LOB INDEX clause for partitioned tables

ORA-22879: cannot use the LOB INDEX clause for partitioned tables

Cause: An attempt was made to specify a LOB INDEX clause in a CREATE TABLE or ALTER TABLE statement for a partitioned table.

Action: Remove the LOB INDEX clause.

ORA-22878: duplicate LOB partition or subpartition specified

ORA-22878: duplicate LOB partition or subpartition specified

Cause: An attempt was made to specify a partition or subpartition that has already been specified for the LOB column.

Action: Remove the duplicate specification.

ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column

ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column

Cause: One or more invalid options were encountered while parsing the physical attributes of a LOB partition or subpartition. Either the LOB partition is in a table partitioned using the HASH method, or the LOB subpartition is in a table subpartitioned using the HASH method. TABLESPACE is the only valid option for a HASH partition or subpartition.

Action: Remove the invalid option(s).

ORA-22876: this user-defined type is not allowed or it cannot be used in this context

ORA-22876: this user-defined type is not allowed or it cannot be used in this context

Cause: An attempt to create a kind of user-defined type which is not allowed, or an attempt to create table columns or use default constructor with a type on which these are not supported.

Action: Ensure that the type is permitted in this context.

ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

Cause: An attempt to drop the primary key of an object table which has a primary key based object identifier

Action: Remove the drop primary key clause

ORA-22874: attribute string is not part of the type string

ORA-22874: attribute string is not part of the type string

Cause: Attribute specified in the user_defined clause is not an attribute of the REF type

Action: Ensure that the name specified in the user_defined clause is the name of a valid attribute of the REF type

ORA-22873: primary key not specified for primary key based object table

ORA-22873: primary key not specified for primary key based object table

Cause: An attempt to create a primary key based object table without specifying a primary key

Action: Specify a primary key and retry the operation

ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

Cause: An attempt to create an OID INDEX on a table with primary key based object identifiers.

Action: Remove the OID INDEX clause