ORA-1652: unable to extend temp segment by 8192 in tablespace 
Author Message
 ORA-1652: unable to extend temp segment by 8192 in tablespace

I get this error report. I can understand that the solution for this
is to add another datafile. But I am confused about one thing
and would appreciate if someone can highlight what am I missing here.

The tablespace which is having this problem is the default tablespace
for the user. Its not a temporary tablespace.

Why does this  message mentions "TEMP SEGMENT"?
Shouldn't database be doing temporary stuff in temporary tablespace?
Does every tablespace have temporary segments or what?

Why doesnt the messaege simply says "Unable to extend segment"?
Why the word TEMP is used in this message?

Any help would be highly appreicated.

Thanks.




Fri, 28 Feb 2003 16:53:16 GMT
 ORA-1652: unable to extend temp segment by 8192 in tablespace

When you create a user you can assign him default temparary tablespace.
If you don't all temporary matters go into default user tablespace. When
report is running it need some space to collect ,sum etc data, and it is
done within temporary segment in temporary tablespace for this user.
You can modify your query - it allways help.
Quote:

> I get this error report. I can understand that the solution for this
> is to add another datafile. But I am confused about one thing
> and would appreciate if someone can highlight what am I missing here.

> The tablespace which is having this problem is the default tablespace
> for the user. Its not a temporary tablespace.

> Why does this  message mentions "TEMP SEGMENT"?
> Shouldn't database be doing temporary stuff in temporary tablespace?
> Does every tablespace have temporary segments or what?

> Why doesnt the messaege simply says "Unable to extend segment"?
> Why the word TEMP is used in this message?

> Any help would be highly appreicated.

> Thanks.





Fri, 28 Feb 2003 18:17:13 GMT
 ORA-1652: unable to extend temp segment by 8192 in tablespace
Thanks Deena but I know this.
let me put my question in another way. All users temporary_tablespace
is set to TEMP. There default tablespace is userstbs.
i get this message "Unable to extend temp segment in userstbs".
WHY. If temp segment ran short of space, then it should say unable to
extend in TEMP and not userstbs.

Any ideas?



Quote:
> When you create a user you can assign him default temparary tablespace.
> If you don't all temporary matters go into default user tablespace. When
> report is running it need some space to collect ,sum etc data, and it is
> done within temporary segment in temporary tablespace for this user.
> You can modify your query - it allways help.



Fri, 28 Feb 2003 20:07:40 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ORA-1652: unable to extend temp segment by 7680 in tablespace

2. ORA-1652: unable to extend temp segment

3. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

4. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

5. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

6. ORA-01652 unable to extend temp segment by num in tablespace name

7. ORA-01652: unable to extend temp segment by 1598 in tablespace

8. ORA-01652: unable to extend temp segment by 1598 in tablespace

9. unexpected ORA-1652: alter index rebuild partition tablespace

10. 01652: unable to extend temp segment

11. Unable to extend temp segment...


 
Powered by phpBB® Forum Software