My Oracle Support Banner

ETL Fails With ORA-30036:Unable to Extend Segment in UNDO Tablespace (Doc ID 2325928.1)

Last updated on DECEMBER 13, 2017

Applies to:

Primavera Data Warehouse - Version and later
Information in this document applies to any platform.


When attempting to run the ETL process (staretl.bat),
the following error occurs.


staretl [INFO] (Message) - === Step 38, Part 1 ====================================================
staretl [INFO] (Message) - === Rollup activity spread to WBS and project (spread_rollup/wbs_spread_rollup.sql)
staretl [DEBUG] (Message) - SQL Plus(4) : [-s] [********] [@runscript.sql] [SCRIPTNAME:spread_rollup/wbs_spread_rollup.sql]
staretl [INFO] (Message) - Roll up activity spread to WBS level :: CURRENT RUN DATE: 03-NOV-17
staretl [INFO] (Message) - Exception: Error during load for table W_WBS_SPREAD_F: ORA-30036: unable to
staretl [INFO] (Message) - extend segment
staretl [INFO] (Message) - (100,W_ACTIVITY_SPREAD_F,W_WBS_SPREAD_F,n/a,n/a)
staretl [INFO] (Message) - declare
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'
staretl [INFO] (Message) - ORA-06512: at "STARUSER.SPREAD_ROLLUP_PKG", line 390
staretl [INFO] (Message) - ORA-06512: at line 4
staretl [INFO] (Progress) - Step 38/51 Part 1/2 - FAILED (84) (0 hours, 11 minutes, 1 seconds, 915 milliseconds)

Steps to Reproduce
1. Run staretl.bat (.sh)




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.