tablespace problem

[sri_dba]

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.

[aspdba]

does your tablespace PROCESS1 have maxsize?

ALTER TABLESPACE PROCESS1 ADD DATAFILE XXXX 100M;

[sri_dba]

I added the datafile earlier but still the error comes

[vinit]

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.

[sri_dba]

Both tables have no rows.

[aspdba]

what is the default and temp table space for the user

ALTER USER
DEFAULT TABLESPACE
TEMPORARY TABLESPACE

[sri_dba]

Problem is solved.

Thanx for ur all info.

[engiri]

Is the version before 9i?
If so use the below option.

Increase MAXTEXTENTS for Temp tablespace

[sri_dba]

yes engiri...

It is production DB 8.1.5,, so i increased it and it is ok now.

Thanx for ur info.