My Oracle Support Banner

ETL Process Fails With Error 'ORA-25153: Temporary Tablespace is Empty' (Doc ID 1672378.1)

Last updated on DECEMBER 03, 2019

Applies to:

Primavera Analytics - Version R1.2 and later
Information in this document applies to any platform.


When attempting to run the STARETL PROCESS, the following error occurs.

staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 85
staretl [INFO] (Message) - Exception: Error during extract for table W_WBS_HIERARCHY_DS: ORA-25153: Temporary Tablespa
staretl [INFO] (Message) - (100,WBSHIERARCHY,W_WBS_HIERARCHY_DS,n/a,n/a)
staretl [INFO] (Message) - BEGIN
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-25153: Temporary Tablespace is Empty
staretl [INFO] (Message) - ORA-02063: preceding line from DSLINK01
staretl [INFO] (Message) - ORA-06512: at "STARUSER.EXTRACT2STAGING", line 132
staretl [INFO] (Message) - ORA-06512: at line 2
staretl [INFO] (Progress) - Finished Script W_WBS_HIERARCHY_DS.sql




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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