My Oracle Support Banner

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

Last updated on MAY 02, 2017

Applies to:

Primavera P6 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!

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.