I tried to run a big process, but i failed.
The following error occured.
unable to extend temp segment by 8091 in tablespace PROCESS01.
Please give some suggestions to avoid this error.
Thanx in advance.
does your tablespace PROCESS1 have maxsize?
ALTER TABLESPACE PROCESS1 ADD DATAFILE XXXX 100M;
I added the datafile earlier but still the error comes
Which Oracle version ?
Check for any hung or active transactions which might have occupied space from v$sort_segment, v$sort_usage.
Try to coalesce. If no usage and still no free space, try to take it offline and then online again else add more space.
Last edited by vinit; 01-21-2004 at 03:07 AM.
Both tables have no rows.
what is the default and temp table space for the user
Problem is solved.
Thanx for ur all info.
Is the version before 9i?
If so use the below option.
Increase MAXTEXTENTS for Temp tablespace
It is production DB 8.1.5,, so i increased it and it is ok now.
Thanx for ur info.
Click Here to Expand Forum to Full Width