Frequent error in UMP: ORA-01652: Unable to extend temp segment by 3596 in tablespace system

Document ID : KB000118478
Last Modified Date : 25/10/2018
Show Technical Document Details
Issue:
Frequent error in UMP: ORA-01652: Unable to extend temp segment by 3596 in tablespace system UMP is also slow and non-responsive at times UIM 8.51 (recently upgraded from 8.4) 
ORA-01652 ERROR in UMP
Environment:
UIM 8.51 (recently upgraded from 8.4)
Windows 2012 R2
Oracle 12.1.02
Resolution:
Consult with your Database Administrator on whether additional datafiles should be added to the tablespace.
For example:
ALTER TABLESPACE 
   SYSTEM
ADD DATAFILE 
   '/ora01/oracle/oradata/system__02.dbf' 
size 100m;