-
tablespace problem
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.
Last edited by vinit; 01-21-2004 at 03:07 AM.
Vinit
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|