Resolving ORA-30036 Error: Unable to Extend Segment by String in Undo Tablespace (KBA1834)
The page describes how to best mask an Oracle database table and how to avoid and resolve ORA-30036: unable to extend segment by string in undo tablespace "tablespace".
At a Glance
| ORA Error: | ORA-30036: unable to extend segment by string in undo tablespace "tablespace" |
|---|---|
| Affects ME versions: | This issue affects all Masking Versions: 4.x, 5.0, 5.1, 5.2, and 5.3. |
| Root Cause: | The specified tablespace has no more space available to perform UPDATE or INSERT. |
| Solution: | The UNDO tablespace is too small. The action here is to either:
For details, contact your DBA for assistance. |
Issue
ORA-30036 error is reported when the current Undo tablespace has no more free space available for the active transactions. This issue has to be resolved in order to proceed.
Troubleshooting
To troubleshoot this error, use 'sqlplus' on a terminal and:
- Check free space in the UNDO tablespace.
- Check if the specified UNDO tablespace in autoextensible.
- Check unexpired extents.
- Check the status of the UNDO extents.
For details on the steps above please see Oracle Doc ID 460481.1.
Related Articles
The following articles may provide more information or related information to this article:
- Masking KBA Articles
- Oracle Docs: Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace (Doc ID 460481.1) (login required).