Oracle 11g 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
- ORA-08002: sequence string.CURRVAL is not yet defined in this session
- Cause: sequence CURRVAL has been selected before sequence NEXTVAL
- Action: select NEXTVAL from the sequence before selecting CURRVAL
- ORA-08003: sequence string.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 represention size.
- Action: Alter or recreate the sequence number with legal limits.
- ORA-08004: sequence string.NEXTVAL string stringVALUE and cannot be instantiated
- Cause: instantiating NEXTVAL would violate one of MAX/MINVALUE
- Action: alter the sequence so that a new value can be requested
- ORA-08005: specified row does not exist
- 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
- ORA-08006: specified row no longer exists
- Cause: the row has been deleted by another user since the operation began
- Action: re-try the operation
- ORA-08007: Further changes to this block by this transaction not allowed
- Cause: Max locks have been reached for this transaction in this block
- Action: Commit changes
- ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string
- 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’
- ORA-08100: index is not valid – see trace file for diagnostics
- Cause: Validate Index detected an inconsistency in its argument index
- Action: Send trace file to your customer support representative
- ORA-08101: index key does not exist file string: (root string, node string) blocks (string)
- Cause: Internal error: possible inconsistency in index
- Action: Send trace file to your customer support representative, along with information on reproducing the error
- ORA-08102: index key not found, obj# string, file string, block string (string)
- Cause: Internal error: possible inconsistency in index
- Action: Send trace file to your customer support representative, along with information on reproducing the error
- ORA-08103: object no longer exists
- 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.
- ORA-08104: this index object string is being online built or rebuilt
- 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
- ORA-08105: Oracle event to turn off smon cleanup for online index build
- Cause: set this event only under the supervision of Oracle development
- Action: debugging only
- ORA-08106: cannot create journal table string.string
- Cause: The online index builder could not create its journal table
- Action: rename your table in conflict or rerun the SQL statement
- * there may be a concurrent online index rebuild on the same object.
- ORA-08108: may not build or rebuild this type of index online
- Cause: only support normal index or IOT top-level index
- Action: change your index type
- ORA-08109: nosort is not a supported option for online index build
- Cause: may not specify nosort for online index build
- Action: get rid of nosort in the index creation command
- ORA-08110: Oracle event to test SMON cleanup for online index build
- Cause: Oracle Kernel test only
- Action: Donot set this event(for test only)
- ORA-08111: a partitioned index may not be coalesced as a whole
- 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)
- ORA-08112: a composite partition may not be coalesced as a whole
- Cause: User attempted to coalesce a composite partition
- Action: Coalesce the index a subpartition at a time (using ALTER INDEX MODIFY SUBPARTITION COALESCE)
- ORA-08113: composite partition index may not be compressed
- Cause: User attempted to compress a composite partition index
- Action: create uncompressed composite partition index
- ORA-08114: can not alter a fake index
- Cause: User attempted to alter a fake index
- Action: drop fake index
- ORA-08115: can not online create/rebuild this index type
- Cause: User attempted to create index type that online doesnot support
- Action: use offline index create/rebuild command
- ORA-08116: can not acquire dml enough lock(S mode) for online index build
- Cause: User attempted to create index online without allowing DML Share lock
- Action: allow DML share lock on the base table
- ORA-08117: Index Organized Table operation released its block pin
- Cause: Block maintenance forced the release of a block pin
- Action: Contact your customer support representative
- ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)
- 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.
- ORA-08119: The new initrans will make the index too big
- 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
- ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index
- 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$.
- ORA-08121: Number of indexes need to be maintained offline exceeds limit for DML
- 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.
- ORA-08122: Online (re)build of index rolled back due to DML conflict
- 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.
- ORA-08175: discrete transaction restriction violated (string)
- 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.
- ORA-08176: consistent read failure; rollback data not available
- 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.
- ORA-08177: can’t serialize access for this transaction
- 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.
- ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL
- Cause: Serializable mode is not supported for user INTERNAL.
- Action: Reconnect as another user and retry the SET TRANSACTION command.
- ORA-08179: concurrency check failed
- 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.
- ORA-08180: no snapshot found based on specified time
- Cause: Could not match the time to an SCN from the mapping table.
- Action: try using a larger time.
- ORA-08181: specified number is not a valid system change number
- Cause: supplied scn was beyond the bounds of a valid scn.
- Action: use a valid scn.
- ORA-08182: operation not supported while in Flashback mode
- Cause: user tried to do dml or ddl while in Flashback mode
- Action: disable Flashback and re-attempt the operation
- ORA-08183: Flashback cannot be enabled in the middle of a transaction
- Cause: user tried to do Flashback in the middle of a transaction
- Action: do a commit
- ORA-08184: attempting to re-enable Flashback while in Flashback mode
- Cause: as stated above
- Action: disable first before re-enabling
- ORA-08185: Flashback not supported for user SYS
- Cause: user logged on as SYS
- Action: logon as a different (non SYS) user.
- ORA-08186: invalid timestamp specified
- Cause: as stated above
- Action: enter a valid timestamp
- ORA-08187: snapshot expression not allowed here
- Cause: A snapshot expression using AS OF was specified when not allowed.
- Action: Do not use the AS OF clause
- ORA-08189: cannot flashback the table because row movement is not enabled
- 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
- ORA-08190: restore point string is from a different incarnation of the database
- 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
- ORA-08191: Flashback Table operation is not supported on remote tables
- 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.
- ORA-08192: Flashback Table operation is not allowed on fixed 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.
- ORA-08193: Flashback Table operation is not allowed on temporary 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.
- ORA-08194: Flashback Table operation is not allowed on materialized views
- 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.
- ORA-08195: Flashback Table operation is not supported on partitions
- 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.
- ORA-08196: Flashback Table operation is not allowed on AQ tables
- 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.
- ORA-08197: Flashback Table operation is not supported on clustered 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.
- ORA-08198: Flashback Table is not supported on object tables, nested 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.
- ORA-08199: Flashback Table operation is not supported on this object
- 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.