-
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
-
What is the extension size for temp tablespace? If it is larger than 42M, that is the problem: you are out of space for temporary operations. If you want this operation, you must have more temp space, or see if someone else is using temp space at the same time.
I do not use autoextend on temp tablespace because it allows users to do stupid queries (like select *all* customer orders sorted for example). Sometimes operations do need lots of temp space, but i want to know about it before i give users/apps gigs and gigs of temp area. But then I'm a mean DBA.
d.
-
Cdutta, if you realy need additional temp space for that procedure to run successfully, simply enlarge the TEMP tablespace by adding a new file, located on some other disk that have space available.
ALTER TABLESPACE temp ADD DATAFILE 'filename' SIZE x .....
HTH,
