Oracle Database Errors or Warnings from Error ORA-30012 to ORA-30024
ORA-30012: undo tablespace ‘string’ does not exist or of wrong type
Cause: the specified undo tablespace does not exist or of the wrong type.
Action: Correct the tablespace name and reissue the statement.
ORA-30013: undo tablespace ‘string’ is currently in use
Cause: the specified undo tablespace is currently used by another instance.
Action: Wait for the undo tablespace to become available or change to another name and reissue the statement.
ORA-30014: operation only supported in Automatic Undo Management mode
Cause: the operation is only supported in automatic undo mode.
Action: restart instance in Automatic Undo Management mode before retrying operation.
ORA-30015: previously offlined undo tablespace ‘string’ is still pending
Cause: the current operation is not allowed because an undo tablespace containing active transactions is pending from a previous SWITCH UNDO operation. The operation will be allowed again after all transactions in the previous undo tablespace are committed.
Action: Wait for all previous transactions to commit before reissuing the current statement.
ORA-30016: undo tablespace ‘string’ is already in use by this instance
Cause: the specified undo tablespace is currently used by this instance. The operation failed.
Action: If the specified undo tablespace name is wrong, reissue the statement with the correct name.
ORA-30017: segment ‘string’ is not supported in string Undo Management mode
Cause: the type of the specified undo segment is incompatible with the current undo management mode of the instance.
Action: Check the undo segment name and the undo management mode and reissue statement if necessary.
ORA-30018: Create Rollback Segment failed, USN string is out of range
Cause: the system runs out of undo segment number. Too many undo segments exist.
Action: drop some of the unused undo segments and retry operation.
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
Cause: This operation only allowed in Manual Undo mode.
Action: restart instance in Manual Undo_Management mode and retry operation.
ORA-30021: Operation not allowed on undo tablespace
Cause: This operation is not allowed on undo tablespaces
Action: Check the tablespace name and reissue command if necessary
ORA-30022: Cannot create segments in undo tablespace
Cause: Cannot create segments in undo tablespace
Action: Check the tablespace name and reissue command
ORA-30023: Duplicate undo tablespace specification
Cause: Cannot create more than one undo tablespace during database creation
Action: Modify the command to contain only one undo tablespace
ORA-30024: Invalid specification for CREATE UNDO TABLESPACE
Cause: You have specified an clause that should not used with CREATE UNDO TABLESPACE
Action: Drop the clause from the command and reissue it.
Above are list of Oracle Database Errors or Warnings from Error ORA-30012 to ORA-30024 received while performing certain operation against Oracle Database or related products.
What are Oracle Database Error Messages?
Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.
Hope this was helpful.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.