Hi DBAs,
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.
Very urgent.
Thanx in advance.
Printable View
Hi DBAs,
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.
Very urgent.
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.
Both tables have no rows.
what is the default and temp table space for the user
ALTER USER
DEFAULT TABLESPACE
TEMPORARY TABLESPACE
Problem is solved.
Thanx for ur all info.
Is the version before 9i?
If so use the below option.
Increase MAXTEXTENTS for Temp tablespace
yes engiri...
It is production DB 8.1.5,, so i increased it and it is ok now.
Thanx for ur info.