SCOPE
Application jobs fails with messages as below.
ORA-20001:
Job failed
ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS
Sharing knowledge is the ultimate key to gaining knowledge…
The only two things that stay with you for life are you & your knowledge...
Live while you can! Teach & inspire while you could & Smile while you have the teeth.
SCOPE
Application jobs fails with messages as below.
ORA-20001:
Job failed
ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS
Below document explains the issue faced after the upgrade, troubleshooting and need for timezone files.