Thursday, November 13, 2008

I am running oracle 10 xe and one of my users complained of error ORA-01652.

As all my tablespaces were more or less full I found the following command useful:
alter tablespace temp add tempfile 'C:\ORACLEXE\ORADATA\XE\TEMP1.DBF' SIZE 500M
using a different path.

I found this and much more helpful info on this page