08000-08174: Data Accessing Messages

This section lists messages generated when Oracle is accessing data or database objects.

ORA-08000: maximum number of session sequence lists exceeded

Cause: This is an internal error message not normally issued.

Action: Contact customer support.

ORA-08001: maximum number of sequences per session exceeded

Cause: An operation requested a resource that was unavailable. The maximum number of user sequences per session is specified by the initialization parameter DC_SEQUENCES. When this maximum is reached, no more requests are processed.

Action: Try the operation again in a few minutes. If this error occurs often, shut down Oracle, increase the DC_SEQUENCES parameter in the initialization parameter file, and restart Oracle.

ORA-08002: name.CURRVAL is not yet defined in this session

Cause: Sequence CURRVAL was selected before sequence NEXTVAL was referenced.

Action: Select NEXTVAL from the sequence before selecting CURRVAL.

ORA-08003: sequence name.NEXTVAL exceeds internal limits

Cause: The sequence was created with unsafe values for some of the parameters. The calculation of NEXTVAL cannot be made because it exceeds the legal representation size.

Action: Alter or recreate the sequence number with legal limits.

ORA-08004: name.NEXTVAL str [MIN][MAX]VALUE and cannot be instantiated

Cause: The requested value of NEXTVAL is greater than MAXVALUE or less than MINVALUE.

Action: Alter the sequence so that a new value can be requested and try again.

ORA-08005: specified row does not exist

Cause: A row with the given ROWID does not exist in any of the specified tables.

Action: Check the query for a misspelled ROWID or table name and try again.

ORA-08006: specified row no longer exists

Cause: The row has been deleted by another user since the operation began.

Action: No action required.

ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = num

Cause: The shared instance being started does not have the same value for the USE_ROW_ENQUEUES initialization parameter as already-running instances.

Action: Make sure all instances' initialization parameter files specify the same value for the USE_ROW_ENQUEUES parameter and try again.

ORA-08100: index is not valid - see trace file for diagnostics

Cause: There is an error in the index validated by VALIDATE INDEX.

Action: Check the relevant trace file. If the problem is not resolvable, contact customer support.

ORA-08101: index key does not exist root dba num, dba num num

Cause: The system detected a possible inconsistency in an index. This is an internal error message that is not normally issued.

Action: Send the trace file to customer support, along with a description of the circumstances that produced the error. Customer support will need the numbers given in the message.

ORA-08102: index key not found, obj# num, dba num num

Cause: The system detected a possible inconsistency in an index. This is an internal error message that is not normally issued.

Action: Send the trace file to customer support, along with a description of the circumstances that produced the error. Customer support will need the numbers given in the message.

ORA-08103: object no longer exists

Cause: The object has been deleted by another user since the operation began.

Action: Remove references to the object.

---