I get this error ORA-01652 when I run a script in Toad. What does it mean and how can I resolve it?
Other scripts I have in toad run well but except this script that throw this error. The same script run when my other colleagues in the same network run it.
Any help will be appreciated.
It means your temporary tablespace is too small to do the work that you are asking Oracle to do. There is probably a big sort or use of temporary tablespace in your script.
Maybe your colleague has a different temporary tablespace assigned to their user. maybe they just got lucky with timing.
Your disk may be almost out of space, or you may have hit the max tablespace size for that tablespace. You might want to talk to your DBA if you aren't sure what to do about this.