I have a scheduled Oracle job (11gR2) that runs once a day at 8pm.. The job fails with this error showing in log:
"ORA-01652: unable to extend temp segment by 64 in tablespace TEMP"
The job is a stored procedure in the Oralce database. If I run the same procedure manually:
The above takes less than 10 minutes to run and I get no error on the IDE and the procedure successfully does its work (insert records in some tables with some complex queries).
I am not the DBA. The DBA just says me to look into the code and there is nothing wrong in database. And they say they assigned 90GB in the TEMP tablespace..
Other scheduled jobs are running without error. How do I fix this problem?