No. 21000 ~ 21999
21001: Unable to start transaction.
Cause Cannot start the transaction.
Action Check the cause of the failure and try again.
21002: No more undo space available.
Cause Insufficient space remains in the undo tablespace.
Action Free up space in the tablespace and specify autoextend in the datafile.
21003: Snapshot is too old.
Cause The snapshot is too old to read.
Action Check the cause of the failure and try again.
21004: No more extent available in tablespace '%1$s'.
Cause Unable to create an additional extent in this table.
Action Free up space in the tablespace and specify autoextend in the datafile.
21005: Unable to initialize datafile %1$s ('%2$d' in tablespace '%3$s').
Cause Cannot initialize the datafile.
Action Check the properties of the datafile.
21006: Unable to extend datafile '%1$d' in tablespace '%2$s'.
Cause Cannot extend the datafile.
Action Adjust the datafile so that it can be extended.
21007: Unable to shrink datafile '%1$d' in tablespace '%2$s'.
Cause Cannot shrink the datafile.
Action Remove segments occupying the datafile and then try again.
21008: Savepoint '%1$s' was not found.
Cause The specified savepoint does not exist.
Action Specify a valid savepoint.
21009: No tempfile was found.
Cause No file exists in the temporary tablespace.
Action Add files in the temporary tablespace and then try again.
21010: Tablespace %1$s was not found.
Cause The specified tablespace does not exist.
Action Specify a valid tablespace.
21011: Seqno overflow: %1$d undo segment.
Cause Cannot continue to increase the sequence numbers of undo segments. The transaction is too long.
Action Raise the uniform size of the undo tablespace, or use the AUTOALLOCATE option.
21012: Unable to serialize access for this transaction.
Cause An attempt was made to access the modified data after the transactions began.
Action The transaction is not accessible.
21013: Undo segment was not found in the UNDO tablespace.
Cause The undo segment does not exist.
Action Specify a valid undo segment.
21014: No space available in SYSTEM tablespace.
Cause Cannot extend the undo segment of SYSTEM tablespace.
Action Increase the size of the SYSTEM tablespace.
21015: Unable to create a system undo segment.
Cause Unable to create an undo segment in the SYSTEM tablespace.
Action Check the cause of the failure and try again.
21016: Insufficient processes (%1$d) for transaction recovery (at least %2$d needed).
Cause Cannot recover non-committed transactions. The number of processes is insufficient.
Action Increase the number of working processes and threads.
21017: Unable to bring undo segment (#%1$d) on/offline: %2$s.
Cause Cannot bring the undo segment online or offline.
Action Specify a valid segment.
21018: Undo segment was not found: '%1$d'.
Cause The specified undo segment does not exist.
Action Specify a valid segment.
21019: Lock held by in-doubt distributed transaction.
Cause Lock is held by an in-doubt transaction.
Action Fix the in-doubt transaction and then try again.
21020: Unable to specify undo tablespace %1$s as default undo tablespace.
Cause The specified undo tablespace cannot be used as the default undo tablespace.
Action Ensure that the specified tablespace is an undo tablespace and is not dropped or offline.
21021: Unable to use tablespace %1$d.
Cause Cannot use the specified temporary tablespace because it was dropped or currently being dropped.
Action Specify another temporary tablespace.
21022: No prepared transaction found with transaction ID %1$s.
Cause Cannot find a prepared transaction with the requested transaction ID.
Action Specify a valid ID.
21023: Unable to execute specified operation during TX recovery.
Cause Cannot execute the operation because transaction is not completely recovered.
Action Try again after the transaction recovery is complete.
21024: Unable to begin new transaction in current server mode.
Cause Tasks cannot be performed in the current server mode.
Action Start the server in NORMAL mode and then execute the task.
21025: Unable to extend segment: maximum number of extensions reached.
Cause The number of extensions has reached the maximum limit specified in the segment.
Action Raise the value of the MAXEXTENTS property of the segment.
21026: Sequence of undo segment %1$d has limit of %2$d.
Cause The undo segment does not exist.
Action Check the cause of the failure and try again.
21027: Unable to use temp tablespace in current server mode.
Cause Cannot use a temporary tablespace in the current server mode.
Action Start the server in NORMAL mode.
21028: Unable to bring minimum number of undo segments online.
Cause The number of online undo segments exceeded the maximum limit.
Action Increase the value of USGMT_ONLINE_MAX parameter, or decrease the value of US GMT_ONLINE_MIN parameter.
21029: Invalid specification for UNDO_TABLESPACE parameter.
Cause The UNDO_TABLESPACE parameter is specified incorrectly.
Action Specify a valid value in the UNDO_TABLESPACE parameter.
21030: DML operation is not permitted.
Cause DML operation is not permitted.
Action The transaction has been opened in read-only mode. Commit or roll back before trying again.
21031: Cannot allocate ITL for PE transaction.
Cause Failed to allocate ITL for PE transaction.
Action Try again.
21032: Failed to perform two-phase commit for the massive cluster system.
Cause Failed in the slave node. The corresponding slave tx has failed.
Action Check the reason and whether the slave node is alive. Try again.
21033: Cannot access a transaction (%1$d.%2$d.%3$d).
Cause Cannot access a transaction (%1$d.%2$d.%3$d).
Action Commit or roll back the transaction and then try again. Or make the status of the corresponding offline tablespace online.
21034: There is no snapshot that corresponds to the specified time.
Cause There is no value that corresponds to the specified time in the mapping table.
Action Increase the value of UNDO_RETENTION to store more snapshots.
21038: Unable to drop the datafile %1$s ('%2$s' in tablespace '%3$s').
Cause Unable to drop the datafile.
Action Check the properties of the datafile.
21039: User '%1$s' cannot be allocated an additional %2$d blocks within the '%3$s' tablespace.
Cause Due to the quota configuration, additional blocks cannot be allocated within the tablespace.
Action Check the quota configuration.
21040: Unable to execute specified operation during in-doubt TX recovery.
Cause Cannot execute the operation because in-doubt transaction is not completely recovered.
Action Fix the in-doubt transaction and then try again.
21042: Unable to begin new transaction in read only server mode.
Cause Tasks cannot be performed in the current server mode.
Action Start the server in READ WRITE mode and then execute the task.
21043: No such temprary file exists in the temporary tablespace.
Cause No such temprary file exists in the temporary tablespace.
Action Check the file name.
21044: The TEMP_TS_CNT_MAX is less than the number of existing temporary tablespaces.
Cause Retry the operation using a valid TEMP_TS_CNT_MAX value.
Action
21045: Unable to bring minimum number of undo segments online.
Cause The number of online undo segments exceeded the maximum limit.
Action Increase the value of USGMT_ONLINE_MAX parameter, or decrease the value of US GMT_ONLINE_MIN parameter.
21046: The snapshot is too old to be used for flashback query.
Cause Since the snapshot is too old, undo log for it is no longer available.
Action Increase the value of _FLASHBACK_QUERY_SNAPSHOT_LIMIT.
Last updated