Oracle 12c R2 Error Codes and Solution Suggestions from ORA-08000 to ORA-08200
- ORA-08000: maximum number of session sequence lists exceeded
Cause: the sequence parent state objects for this session are all used
Action: an internal error; quit the session and begin a new one
Cause: sequence CURRVAL has been selected before sequence NEXTVAL
Action: select NEXTVAL from the sequence before selecting CURRVAL
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 represention size.
Action: Alter or recreate the sequence number with legal limits.
Cause: instantiating NEXTVAL would violate one of MAX/MINVALUE
Action: alter the sequence so that a new value can be requested
Cause: A row with the given rowid does not exist in any of the tables given
Action: check the query for misspellings of table names and the rowid
Cause: the row has been deleted by another user since the operation began
Action: re-try the operation
Cause: Max locks have been reached for this transaction in this block
Action: Commit changes
Cause: the shared instance being started does not have the same value for use_row_enqueues as already running instances
Action: ensure that all instances’ INIT.ORA files specify the same value for the parameter ‘use_row_enqueues’
Cause: Validate Index detected an inconsistency in its argument index
Action: Send trace file to your customer support representative
Cause: Internal error: possible inconsistency in index
Action: Send trace file to your customer support representative, along with information on reproducing the error
Cause: Internal error: possible inconsistency in index
Action: Send trace file to your customer support representative, along with information on reproducing the error
Cause: The object has been deleted by another user since the operation began, or a prior incomplete recovery restored the database to a point in time during the deletion of the object.
Action: Delete the object if this is the result of an incomplete recovery.
Cause: the index is being created or rebuild or waited for recovering from the online (re)build
Action: wait the online index build or recovery to complete
Cause: set this event only under the supervision of Oracle development
Action: debugging only
Cause: The online index builder could not create its journal table
Action: Rename the conflicting table or rerun the SQL statement. There * may be a concurrent online index rebuild on the same object. rename your table in conflict or rerun the SQL statement * there may be a concurrent online index rebuild on the same object.
Cause: only support normal index or IOT top-level index
Action: change your index type
Cause: may not specify nosort for online index build
Action: get rid of nosort in the index creation command
Cause: Oracle Kernel test only
Action: Donot set this event(for test only)
Cause: User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal
Action: Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)
Cause: User attempted to coalesce a composite partition
Action: Coalesce the index a subpartition at a time (using ALTER INDEX MODIFY SUBPARTITION COALESCE)
Cause: User attempted to compress a composite partition index
Action: create uncompressed composite partition index
Cause: User attempted to alter a fake index
Action: drop fake index
Cause: User attempted to create index type that online doesnot support
Action: use offline index create/rebuild command
Cause: User attempted to create index online without allowing DML Share lock
Action: allow DML share lock on the base table
Cause: Block maintenance forced the release of a block pin
Action: Contact your customer support representative
Cause: Deferred Foreign Key constraints cannot be enforced due to the index key being too big and built on a non-default DB_BLOCK_SIZE.
Action: First try to drop the Foreign Key and then the primary key.
Cause: Specifying the initrans need additional space to hold the index key which might make the index too big
Action: Try giving a smaller initrans value
Cause: Alter index Build/Rebuild online require existing of SYS.IND_ONLINE$ table.
Action: User/DBA needs to create sys.ind_online$ before alter the index /rdbms/admin/catcio.sql contains script to create ind_online$.
Cause: Too many indexes needed to be maintained. The limit is 2^16 indexes for each DML statement
Action: Make sure the index maintainance is online. If indexes need to be maintained offline, drop some indexes.
Cause: The online (re)build journal is inconsistent with ongoing DML and cannot be used successfully to complete the online index (re)build.
Action: Reissue the online (re)build operation, after performing any cleanup, if needed.
Cause: An attempt was made to perform an action that is not currently supported in a discrete transaction.
Action: Rollback the transaction, and retry it as a normal transaction.
Cause: Encountered data changed by an operation that does not generate rollback data : create index, direct load or discrete transaction.
Action: In read/write transactions, retry the intended operation. Read only transactions must be restarted.
Cause: Encountered data changed by an operation that occurred after the start of this serializable transaction.
Action: In read/write transactions, retry the intended operation or transaction.
Cause: Serializable mode is not supported for user INTERNAL.
Action: Reconnect as another user and retry the SET TRANSACTION command.
Cause: Encountered data changed by an operation that occurred after a specific snapshot. This is usually used to indicate that a particular cached copy of a datablock is stale. This is used for internal use for now.
Action: refresh the cached copy of the datablock and retry operation.
Cause: Could not match the time to an SCN from the mapping table.
Action: try using a larger time.
Cause: supplied scn was beyond the bounds of a valid scn.
Action: use a valid scn.
Cause: user tried to do dml or ddl while in Flashback mode
Action: disable Flashback and re-attempt the operation
Cause: user tried to do Flashback in the middle of a transaction
Action: do a commit
Cause: as stated above
Action: disable first before re-enabling
Cause: user logged on as SYS
Action: logon as a different (non SYS) user.
Cause: as stated above
Action: enter a valid timestamp
Cause: A snapshot expression using AS OF was specified when not allowed.
Action: Do not use the AS OF clause
Cause: An attempt was made to perform Flashback Table operation on a table for which row movement has not been enabled. Because the Flashback Table does not preserve the rowids, it is necessary that row movement be enabled on the table.
Action: Enable row movement on the table
Cause: An attempt was made to perform Flashback Table operation using a restore point from a different incarnation of the database
Action: Provide a restore point from the current database incarnation
Cause: An attempt was made to perform Flashback Table operation on a remote table. This is not permitted.
Action: Do not perform a Flashback Table operation on remote tables.
Cause: An attempt was made to perform Flashback Table operation on a fixed table. This is not permitted.
Action: Do not perform a Flashback Table operation on fixed tables.
Cause: An attempt was made to perform Flashback Table operation on a temporary table. This is not permitted.
Action: Do not perform a Flashback Table operation on temporary tables.
Cause: An attempt was made to perform Flashback Table operation on a materialized view. This is not permitted.
Action: Do not perform a Flashback Table operation on materialized views or snapshot logs.
Cause: An attempt was made to perform Flashback Table operation on a partition. This is not permitted.
Action: Do not perform a Flashback Table operation on partitions.
Cause: An attempt was made to perform Flashback Table operation on AQ tables. This is not permitted.
Action: Do not perform a Flashback Table operation on AQ tables.
Cause: An attempt was made to perform Flashback Table operation on a clustered table. This is not permitted.
Action: Do not perform a Flashback Table operation on clustered tables.
Cause: An attempt was made to perform Flashback Table operation on a object table or a nested table or a table with nested table column. This is not permitted.
Action: Do not perform a Flashback Table operation on such tables.
Cause: An attempt was made to perform Flashback Table operation on an object on which the operation is not supported.
Action: Do not perform a Flashback Table operation on such objects.