Oracle Error Messages: 06/15/12

Friday 15 June 2012

ORA-38430: Operation string not supported in the current release.

ORA-38430: Operation string not supported in the current release.

Cause: An attempt was made to perform an unsupported operation.

Action: Do not use the operation.

ORA-38429: invalid datatype for a stored attribute: string

ORA-38429: invalid datatype for a stored attribute: string

Cause: The (resulting) datatype for the attribute was not appropriate for storing.

Action: Choose a stored attribute that has a resulting datatype of NUMBER, VARCHAR2, CHAR or DATE.

ORA-38428: too many attributes selected for indexing

ORA-38428: too many attributes selected for indexing

Cause: An attempt was made to create an expression filter index with more than 490 indexed attributes.

Action: Remove some of the indexed attributes. Make sure that the default indexed attributes associated with the attribute set combined with the indexed attributes specified in the Create Index Parameters clause are less than or equal to 490

ORA-38427: attribute string does not exist

ORA-38427: attribute string does not exist

Cause: An attempt was made to use an attribute set that does not exist.

Action: Create the attribute set.

ORA-38426: attribute set assigned to an expression set may not be dropped

ORA-38426: attribute set assigned to an expression set may not be dropped

Cause: An attempt was made to drop an attribute set when it is still associated with an expression set.

Action: Un-assign the attribute set from the expression set before dropping it.

ORA-38425: attribute set used for an index object may not be unassigned

ORA-38425: attribute set used for an index object may not be unassigned

Cause: An attempt was made to un-assign an attribute set from an expression set when there is an Expression Filter index defined on the column.

Action: Drop the index before un-assigning the attribute set.

ORA-38424: no attribute set currently assigned to the expression set

ORA-38424: no attribute set currently assigned to the expression set

Cause: An attempt was made to un-assign an attribute set from an expression set when there is no attribute set assigned to it.

Action: No action is required.

ORA-38423: Attribute set created from an ADT may not be extended.

ORA-38423: Attribute set created from an ADT may not be extended.

Cause: An attempt was made to add an elementary attribute to an attribute set created from an ADT.

Action: Create a new attribute set and add all the required elementary attributes one at a time.

ORA-38422: invalid datatype for the attribute: string

ORA-38422: invalid datatype for the attribute: string

Cause: An attempt was made to create an attribute with invalid datatype.

Action: If the data type of the attribute is an ADT, make sure that the type exists.

ORA-38421: attribute string already exists

ORA-38421: attribute string already exists

Cause: An attribute with a matching name (or form) already exists in the attribute set.

Action: Drop the existing attribute or choose a different name for the new attribute.

ORA-38420: invalid stored attribute sub-expression: string

ORA-38420: invalid stored attribute sub-expression: string

Cause: The sub-expression used for the stored expression was invalid.

Action: Set serveroutput ON and repeat the operation for additional information.

ORA-38419: invalid identifier in attribute : string

ORA-38419: invalid identifier in attribute : string

Cause: An identifier used in the stored or indexed attribute sub-expression was not defined or was invalid.

Action: Create all the required elementary attributes and user-defined functions and try again.

ORA-38418: ADT associated with the attribute set string does not exist

ORA-38418: ADT associated with the attribute set string does not exist

Cause: The ADT with the same name as the attribute set was not found in the current schema.

Action: Drop the attribute set and recreate it.

ORA-38417: attribute set string does not exist

ORA-38417: attribute set string does not exist

Cause: An attempt was made to use an attribute set that does not exist.

Action: Create the attribute set or choose an existing attribute set.

ORA-38416: A stored attribute may not be longer then 300 characters.

ORA-38416: A stored attribute may not be longer then 300 characters.

Cause: An attempt was made to create a stored or indexed attribute longer than 300 characters.

Action: A predicate with such attribute may not be indexed. It will be evaluated as sparse predicate.

ORA-38415: invalid name or datatype for the attribute: string

ORA-38415: invalid name or datatype for the attribute: string

Cause: An invalid name or datatype was used for the attribute.

Action: Set serveroutput ON and repeat the operation for additional information.

ORA-38414: invalid datatype for the attribute string

ORA-38414: invalid datatype for the attribute string

Cause: The datatype specified for the attribute was invalid.

Action: If the datatype is an ADT, make sure that the ADT exists and the current user has execute permissions to it.

ORA-38413: elementary attribute name may not be longer than 32 characters

ORA-38413: elementary attribute name may not be longer than 32 characters

Cause: An attempt was made to create an elementary attribute with a name longer than 32 characters.

Action: Use a shorter name for the elementary attribute.

ORA-38412: Expression set column string does not exist.

ORA-38412: Expression set column string does not exist.

Cause: The column storing expressions does not exist.

Action: Pass a valid name for the column storing expressions.

ORA-38411: invalid datatype for the column storing expressions

ORA-38411: invalid datatype for the column storing expressions

Cause: An attempt was made to create an expression column from a column of invalid datatype.

Action: Create a VARCHAR2 or CHAR column to store expressions in a table.

ORA-38410: schema extension not allowed for the table name

ORA-38410: schema extension not allowed for the table name

Cause: An attempt was made to use a schema extended name for the table storing expressions.

Action: The table storing expressions and the corresponding attribute set should be created in the same schema.

ORA-38409: invalid name or option for the attribute set: string

ORA-38409: invalid name or option for the attribute set: string

Cause: An invalid name or option was used for the attribute set.

Action: Set serveroutput ON and repeat the operation for additional information.

ORA-38408: The ADT string does not exist in the current schema.

ORA-38408: The ADT string does not exist in the current schema.

Cause: An attempt was made to create the attribute set from a nonexistent ADT.

Action: Make sure that the ADT with the same name as the attribute set exists in the current schema.

ORA-38407: The ADT associated with the attribute set already exists.

ORA-38407: The ADT associated with the attribute set already exists.

Cause: The Abstract type (ADT) with the same name as the attribute set already exists in the current schema.

Action: Create the attribute set for the existing ADT or drop the ADT.

ORA-38406: attribute set string already exists

ORA-38406: attribute set string already exists

Cause: An attribute set with a matching name already exists in the current schema.

Action: Drop the existing attribute set or choose a different name.

ORA-38405: quotes not allowed in the attribute set name

ORA-38405: quotes not allowed in the attribute set name

Cause: The attribute set name contained quotes.

Action: Remove quotes in the attribute set name.

ORA-38404: schema extension not allowed for the attribute set name

ORA-38404: schema extension not allowed for the attribute set name

Cause: There was a schema extension for the attribute set name. Attribute sets are always created in the current schema and thus schema extended names are not allowed.

Action: Create the attribute set from the appropriate schema.

ORA-38403: attribute set name may not be longer than 22 characters

ORA-38403: attribute set name may not be longer than 22 characters

Cause: The attribute set name was longer than 22 characters.

Action: Choose a name that has 22 or fewer characters.

ORA-38402: invalid name: empty string or spaces in the name

ORA-38402: invalid name: empty string or spaces in the name

Cause: There were spaces in the name.

Action: Remove spaces in the name or use quotes around the name.

ORA-38401: synonym string not allowed

ORA-38401: synonym string not allowed

Cause: An attempt was made to use a synonym for a data type of an attribute or a table alias.

Action: Use the object name instead of the synonym.

ORA-38312: original name is used by an existing object

ORA-38312: original name is used by an existing object

Cause: An attempt was made to recover an object preserving the original name, but that name is taken up by some other object.

Action: use the RENAME clause to recover the object with a different name.

ORA-38311: cannot purge objects owned by other users

ORA-38311: cannot purge objects owned by other users

Cause: An attempt was made to purge an object which is owned by some other user.

Action: Cannot purge this object.

ORA-38310: cannot purge tablespace for other users

ORA-38310: cannot purge tablespace for other users

Cause: An attempt was made to purge the tablespace for a different user by a user who does not have system DBA priviledges.

Action: Cannot purge the tablespace for some other user.

ORA-38309: object not purgable

ORA-38309: object not purgable

Cause: An attempt was made to purge an object that is either not purgable or else dependent upon some other object.

Action: Cannot purge this object.

ORA-38307: object not in RECYCLE BIN

ORA-38307: object not in RECYCLE BIN

Cause: Trying to Purge the object which is not in RecycleBin.

Action: Only the objects in RecycleBin can be PURGEDED.

ORA-38306: this object is not recoverable standalone

ORA-38306: this object is not recoverable standalone

Cause: Trying to flashback drop an object other than of type TABLE.

Action: Only tables are recoverable.

ORA-38305: object not in RECYCLE BIN

ORA-38305: object not in RECYCLE BIN

Cause: Trying to Flashback Drop an object which is not in RecycleBin.

Action: Only the objects in RecycleBin can be Flashback Dropped.

ORA-38304: missing or invalid user name

ORA-38304: missing or invalid user name

Cause: A valid user name was expected.

Action: Specify a valid user name.

ORA-38303: invalid option for PURGE TABLESPACE

ORA-38303: invalid option for PURGE TABLESPACE

Cause: Either a token other than USER was found following the tablespace name or some text was found following USER lamp;lt;lamp;nbsp;user namelamp;gt;.

Action: Place nothing or only USER lamp;lt;lamp;nbsp;user namelamp;gt; after the tablespace name

ORA-38201: assert if pin during flush

ORA-38201: assert if pin during flush

Cause: internal use only

Action: enables checking for bugs in upper layers when there is a pin on a buffer or there are users for buffer and we are trying to flush the object associated with the buffer

ORA-38105: Delete not yet supported when Update row-migration is possible

ORA-38105: Delete not yet supported when Update row-migration is possible

Cause: When Update Row-Migration is possible, Delete in MERGE is not yet supported

Action: none

ORA-38104: Columns referenced in the ON Clause cannot be updated: string

ORA-38104: Columns referenced in the ON Clause cannot be updated: string

Cause: LHS of UPDATE SET contains the columns referenced in the ON Clause

Action: none

ORA-38103: Invalid column in the UPDATE SET Clause: string

ORA-38103: Invalid column in the UPDATE SET Clause: string

Cause: UPDATE SET clause refers to the source table columns in the LHS

Action: none

ORA-38102: Invalid column in the INSERT WHERE Clause: string

ORA-38102: Invalid column in the INSERT WHERE Clause: string

Cause: INSERT WHERE clause refers to the destination table columns

Action: none

ORA-38101: Invalid column in the INSERT VALUES Clause: string

ORA-38101: Invalid column in the INSERT VALUES Clause: string

Cause: INSERT VALUES clause refers to the destination table columns

Action: none

ORA-38029: object statistics are locked

ORA-38029: object statistics are locked

Cause: An attept was made to modify optimizer statistics of the object.

Action: Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS procedure on base table(s). Retry the operation if it is okay to update statistics.

ORA-37999: Serious OLAP error: string. Please contact Oracle Technical Support.

ORA-37999: Serious OLAP error: string. Please contact Oracle Technical Support.

Cause: Something unexpected occurred in the OLAP system

Action: Contact Oracle technical support

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-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.

Cause: Ran out of temporary tablespace storage.

Action: Increase the amount of temporary tablespace storage.

ORA-37602: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

ORA-37602: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

Cause: Ran out of temporary tablespace storage.

Action: Increase the amount of temporary tablespace storage.

ORA-37601: (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

ORA-37601: (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

Cause: Ran out of temporary tablespace storage.

Action: Increase the amount of temporary tablespace storage.

ORA-37600: (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed

ORA-37600: (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed

Cause: Unexpected error occurred to parallel update servers.

Action: Check the error underneath and act accordingly. AW may need to be detached.

ORA-37185: length of string (string) exceeds maximum (string)

ORA-37185: length of string (string) exceeds maximum (string)

Cause: The user passed an excessively long value

Action: Specify a legal value

ORA-37184: illegal value string for ADVMODE

ORA-37184: illegal value string for ADVMODE

Cause: The user passed a value other than ADVICE_DEFAULT, ADVICE_FAST or ADVICE_FULL to DBMS_AW.ADVISE_SPARSITY *Acton: Supply a legal value instead

Action: none

ORA-37183: illegal value string for PARTBY

ORA-37183: illegal value string for PARTBY

Cause: The user passed a value other than PARTBY_DEFAULT, PARTBY_NONE or PARTBY_FORCE to DBMS_AW.ADVISE_SPARSITY *Acton: Supply a legal value instead

Action: none

ORA-37182: you may only specify one dimension to partition

ORA-37182: you may only specify one dimension to partition

Cause: The user passed a DIMENSION_SOURCE_T to ADVISE_SPARSITY which specified partitioning on more than one dimension

Action: Remove all but one of the partitioning requests

ORA-37181: expected exactly string columns for dimension string, got string

ORA-37181: expected exactly string columns for dimension string, got string

Cause: Expected a certain number of source columns for the dimension. Either none or the wrong number of columns was specified.

Action: Specify the right number of columns, or change the dimension to another type

ORA-37180: expected exactly one column for dimension string, got string

ORA-37180: expected exactly one column for dimension string, got string

Cause: Expected a single source column for the dimension. Either none or more than one was specified.

Action: Specify exactly one column, or change the dimension to another type