Purge Of Sessions Logs Failed in ODI and getting error "ORA-30036: Unable To Extend Segment By 8 In Undo Tablespace 'UNDOTBS1'"
(Doc ID 2507929.1)
Last updated on AUGUST 29, 2024
Applies to:
Hyperion Financial Data Quality Management - Version 11.1.2.4.000 and laterInformation in this document applies to any platform.
Goal
While trying to Purge ODI Logs from ODI Console, UNDOTBS1 Tablespace size gets full and finally ODI throws below error -
Purge of load plan logs is successful. Purge of sessions logs failed. com.sunopsis.dwg.SQLWorkReposException:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
In ODI console few of the sessions will be in waiting state and those sessions cannot be purged, only the active sessions and completed sessions can be purged.
In-order to purge the waiting sessions those sessions should be deleted from ODI studio.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |