{"id":1797,"date":"2016-03-19T13:35:27","date_gmt":"2016-03-19T10:35:27","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1797"},"modified":"2016-10-21T13:37:00","modified_gmt":"2016-10-21T10:37:00","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-08000-to-ora-08200","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-08000-to-ora-08200\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-08000 to ORA-08200"},"content":{"rendered":"<p><strong>Oracle 11g Error Codes and Solution Suggestions from ORA-08000 to ORA-08200<\/strong><\/p>\n<dl>\n<dt><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08000: maximum number of session sequence lists exceeded<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0the sequence parent state objects for this session are all used<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0an internal error; quit the session and begin a new one<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2685\"><\/a><a name=\"ORA-08002\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08002: sequence\u00a0<i>string<\/i>.CURRVAL is not yet defined in this session<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0sequence CURRVAL has been selected before sequence NEXTVAL<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0select NEXTVAL from the sequence before selecting CURRVAL<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2686\"><\/a><a name=\"ORA-08003\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08003: sequence\u00a0<i>string<\/i>.NEXTVAL exceeds internal limits<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Alter or recreate the sequence number with legal limits.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2687\"><\/a><a name=\"ORA-08004\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08004: sequence\u00a0<i>string<\/i>.NEXTVAL\u00a0<i>string<\/i>\u00a0<i>string<\/i>VALUE and cannot be instantiated<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0instantiating NEXTVAL would violate one of MAX\/MINVALUE<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0alter the sequence so that a new value can be requested<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2688\"><\/a><a name=\"ORA-08005\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08005: specified row does not exist<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0A row with the given rowid does not exist in any of the tables given<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0check the query for misspellings of table names and the rowid<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2689\"><\/a><a name=\"ORA-08006\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08006: specified row no longer exists<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0the row has been deleted by another user since the operation began<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0re-try the operation<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2690\"><\/a><a name=\"ORA-08007\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08007: Further changes to this block by this transaction not allowed<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Max locks have been reached for this transaction in this block<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Commit changes<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2691\"><\/a><a name=\"ORA-08008\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08008: another instance is mounted with USE_ROW_ENQUEUES =\u00a0<i>string<\/i><\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0the shared instance being started does not have the same value for use_row_enqueues as already running instances<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0ensure that all instances&#8217; INIT.ORA files specify the same value for the parameter &#8216;use_row_enqueues&#8217;<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2692\"><\/a><a name=\"ORA-08100\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08100: index is not valid &#8211; see trace file for diagnostics<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Validate Index detected an inconsistency in its argument index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Send trace file to your customer support representative<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2693\"><\/a><a name=\"ORA-08101\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08101: index key does not exist file\u00a0<i>string<\/i>: (root\u00a0<i>string<\/i>, node\u00a0<i>string<\/i>) blocks (<i>string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Internal error: possible inconsistency in index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Send trace file to your customer support representative, along with information on reproducing the error<\/span><\/span><\/span><\/dd>\n<p><!--more--><\/p>\n<dt><a name=\"sthref2694\"><\/a><a name=\"ORA-08102\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08102: index key not found, obj#\u00a0<i>string<\/i>, file\u00a0<i>string<\/i>, block\u00a0<i>string<\/i>\u00a0(<i>string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Internal error: possible inconsistency in index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Send trace file to your customer support representative, along with information on reproducing the error<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2695\"><\/a><a name=\"ORA-08103\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08103: object no longer exists<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Delete the object if this is the result of an incomplete recovery.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2696\"><\/a><a name=\"ORA-08104\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08104: this index object\u00a0<i>string<\/i>\u00a0is being online built or rebuilt<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0the index is being created or rebuild or waited for recovering from the online (re)build<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0wait the online index build or recovery to complete<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2697\"><\/a><a name=\"ORA-08105\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08105: Oracle event to turn off smon cleanup for online index build<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0set this event only under the supervision of Oracle development<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0debugging only<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2698\"><\/a><a name=\"ORA-08106\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08106: cannot create journal table\u00a0<i>string<\/i>.<i>string<\/i><\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0The online index builder could not create its journal table<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0rename your table in conflict or rerun the SQL statement<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\">* there may be a concurrent online index rebuild on the same object.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2699\"><\/a><a name=\"ORA-08108\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08108: may not build or rebuild this type of index online<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0only support normal index or IOT top-level index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0change your index type<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2700\"><\/a><a name=\"ORA-08109\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08109: nosort is not a supported option for online index build<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0may not specify nosort for online index build<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0get rid of nosort in the index creation command<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2701\"><\/a><a name=\"ORA-08110\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08110: Oracle event to test SMON cleanup for online index build<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Oracle Kernel test only<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Donot set this event(for test only)<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2702\"><\/a><a name=\"ORA-08111\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08111: a partitioned index may not be coalesced as a whole<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2703\"><\/a><a name=\"ORA-08112\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08112: a composite partition may not be coalesced as a whole<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to coalesce a composite partition<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Coalesce the index a subpartition at a time (using ALTER INDEX MODIFY SUBPARTITION COALESCE)<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2704\"><\/a><a name=\"ORA-08113\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08113: composite partition index may not be compressed<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to compress a composite partition index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0create uncompressed composite partition index<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2705\"><\/a><a name=\"ORA-08114\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08114: can not alter a fake index<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to alter a fake index<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0drop fake index<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2706\"><\/a><a name=\"ORA-08115\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08115: can not online create\/rebuild this index type<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to create index type that online doesnot support<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0use offline index create\/rebuild command<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2707\"><\/a><a name=\"ORA-08116\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08116: can not acquire dml enough lock(S mode) for online index build<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0User attempted to create index online without allowing DML Share lock<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0allow DML share lock on the base table<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2708\"><\/a><a name=\"ORA-08117\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08117: Index Organized Table operation released its block pin<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Block maintenance forced the release of a block pin<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Contact your customer support representative<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2709\"><\/a><a name=\"ORA-08118\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08118: Deferred FK constraints cannot be enforced, index too big (<i>string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Deferred Foreign Key constraints cannot be enforced due to the index key being too big and built on a non-default DB_BLOCK_SIZE.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0First try to drop the Foreign Key and then the primary key.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2710\"><\/a><a name=\"ORA-08119\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08119: The new initrans will make the index too big<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Specifying the initrans need additional space to hold the index key which might make the index too big<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Try giving a smaller initrans value<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2711\"><\/a><a name=\"ORA-08120\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Alter index Build\/Rebuild online require existing of SYS.IND_ONLINE$ table.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0User\/DBA needs to create sys.ind_online$ before alter the index \/rdbms\/admin\/catcio.sql contains script to create ind_online$.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2712\"><\/a><a name=\"ORA-08121\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08121: Number of indexes need to be maintained offline exceeds limit for DML<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Too many indexes needed to be maintained. The limit is 2^16 indexes for each DML statement<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Make sure the index maintainance is online. If indexes need to be maintained offline, drop some indexes.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2713\"><\/a><a name=\"ORA-08122\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08122: Online (re)build of index rolled back due to DML conflict<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0The online (re)build journal is inconsistent with ongoing DML and cannot be used successfully to complete the online index (re)build.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Reissue the online (re)build operation, after performing any cleanup, if needed.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2714\"><\/a><a name=\"ORA-08175\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08175: discrete transaction restriction violated (<i>string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform an action that is not currently supported in a discrete transaction.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Rollback the transaction, and retry it as a normal transaction.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2715\"><\/a><a name=\"ORA-08176\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08176: consistent read failure; rollback data not available<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Encountered data changed by an operation that does not generate rollback data : create index, direct load or discrete transaction.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0In read\/write transactions, retry the intended operation. Read only transactions must be restarted.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2716\"><\/a><a name=\"ORA-08177\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08177: can&#8217;t serialize access for this transaction<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Encountered data changed by an operation that occurred after the start of this serializable transaction.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0In read\/write transactions, retry the intended operation or transaction.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2717\"><\/a><a name=\"ORA-08178\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Serializable mode is not supported for user INTERNAL.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Reconnect as another user and retry the SET TRANSACTION command.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2718\"><\/a><a name=\"ORA-08179\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08179: concurrency check failed<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Encountered 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.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0refresh the cached copy of the datablock and retry operation.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2719\"><\/a><a name=\"ORA-08180\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08180: no snapshot found based on specified time<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0Could not match the time to an SCN from the mapping table.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0try using a larger time.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2720\"><\/a><a name=\"ORA-08181\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08181: specified number is not a valid system change number<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0supplied scn was beyond the bounds of a valid scn.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0use a valid scn.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2721\"><\/a><a name=\"ORA-08182\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08182: operation not supported while in Flashback mode<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0user tried to do dml or ddl while in Flashback mode<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0disable Flashback and re-attempt the operation<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2722\"><\/a><a name=\"ORA-08183\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08183: Flashback cannot be enabled in the middle of a transaction<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0user tried to do Flashback in the middle of a transaction<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0do a commit<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2723\"><\/a><a name=\"ORA-08184\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08184: attempting to re-enable Flashback while in Flashback mode<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0as stated above<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0disable first before re-enabling<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2724\"><\/a><a name=\"ORA-08185\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08185: Flashback not supported for user SYS<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0user logged on as SYS<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0logon as a different (non SYS) user.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2725\"><\/a><a name=\"ORA-08186\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08186: invalid timestamp specified<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0as stated above<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0enter a valid timestamp<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2726\"><\/a><a name=\"ORA-08187\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08187: snapshot expression not allowed here<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0A snapshot expression using AS OF was specified when not allowed.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not use the AS OF clause<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2727\"><\/a><a name=\"ORA-08189\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08189: cannot flashback the table because row movement is not enabled<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Enable row movement on the table<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2728\"><\/a><a name=\"ORA-08190\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08190: restore point\u00a0<i>string<\/i>\u00a0is from a different incarnation of the database<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation using a restore point from a different incarnation of the database<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Provide a restore point from the current database incarnation<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2729\"><\/a><a name=\"ORA-08191\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08191: Flashback Table operation is not supported on remote tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a remote table. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on remote tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2730\"><\/a><a name=\"ORA-08192\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08192: Flashback Table operation is not allowed on fixed tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a fixed table. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on fixed tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2731\"><\/a><a name=\"ORA-08193\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08193: Flashback Table operation is not allowed on temporary tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a temporary table. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on temporary tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2732\"><\/a><a name=\"ORA-08194\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08194: Flashback Table operation is not allowed on materialized views<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a materialized view. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on materialized views or snapshot logs.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2733\"><\/a><a name=\"ORA-08195\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08195: Flashback Table operation is not supported on partitions<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a partition. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on partitions.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2734\"><\/a><a name=\"ORA-08196\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08196: Flashback Table operation is not allowed on AQ tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on AQ tables. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on AQ tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2735\"><\/a><a name=\"ORA-08197\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08197: Flashback Table operation is not supported on clustered tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on a clustered table. This is not permitted.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on clustered tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2736\"><\/a><a name=\"ORA-08198\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08198: Flashback Table is not supported on object tables, nested tables<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An 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.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on such tables.<\/span><\/span><\/span><\/dd>\n<dt><a name=\"sthref2737\"><\/a><a name=\"ORA-08199\"><\/a><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><b><span style=\"color: #1d5aab;\">ORA-08199: Flashback Table operation is not supported on this object<\/span><\/b><\/span><\/span><\/dt>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Cause:<\/b>\u00a0An attempt was made to perform Flashback Table operation on an object on which the operation is not supported.<\/span><\/span><\/span><\/dd>\n<dd><span style=\"font-family: inherit;\"><span style=\"font-size: small;\"><span style=\"color: #222222;\"><b>Action:<\/b>\u00a0Do not perform a Flashback Table operation on such objects.<\/span><\/span><\/span><\/dd>\n<dd><\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 11g Error Codes and Solution Suggestions from ORA-08000 to ORA-08200 ORA-08000: maximum number of session sequence lists exceeded Cause:\u00a0the sequence parent state objects for this session are all used Action:\u00a0an internal error; quit the session and begin a new one ORA-08002: sequence\u00a0string.CURRVAL is not yet defined in this session Cause:\u00a0sequence CURRVAL has been selected&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1797","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-sZ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1797","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1797"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1797\/revisions"}],"predecessor-version":[{"id":1798,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1797\/revisions\/1798"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1797"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}