My Oracle Support Banner

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 MAY 03, 2021

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.4.000 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.