Hi Oracle Support Team,
I got an oracle error of "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" when to run a scheduled customized report. Anyway, I have set up the TEMP table spaces which contains 7 temp files ( 32 GB per each. Total size is 225 GB.). I also made sure that I have set auto extent for each temp file. Before to run the scheduled report, I have checked that the first three temp files had been used and full. So during running the scheduled report, I monitored that it tried to use the 4th temp file until it was full and the scheduled report failed. In theory, I expected that if the 4th temp file has been used and full, it would be automatically used the next temp file. Is it correct? If yes, I don't know why it did not use the rest of temp file with free spaces. Is it any configuration incorrectly? Please advance. Many thanks.
Regards.
Dicky