Hi all

I need urgent help. I ran out of temp space. I had a user
ran a stored procedure and got the following set of errors:
ERROR at line 1:
ORA-01237: cannot extend datafile 1025
ORA-01110: data file 1025: 'G:\ORACLE\ORADATA\RISK\TEMP1.DBF'
ORA-27068: skgfdisp: buffer is not aligned properly
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.
ORA-06512: at "RISK.SP_ACQ_VALIDATE_COUNTS_DWHSE", line 194
ORA-06512: at line 1
I am running Oracle 8i v 8.1.6.2 On Windows NT.

When I checked the space on G: drive I only had 42 M left.
also temp was set to have autoextend on.
How can I fix this problem? Please help.
This is the production box. Should temp tablespace have the autoextend on?

Thank you