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 AUGUST 11, 2021

Applies to:

Hyperion Financial Data Quality Management - Version and later
Information in this document applies to any platform.


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.


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

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