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.
