Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: oracle space problem. Error code:ORA-01652
Hi,
Just to add my two cents worth and perhaps clarify some points.
When you say the dba dropped and created a new segment do you mean tablespace ? Segments are physical storage assoc. with objects (e.g. tables, indexes) and reside within tablespaces. Temporary segments are built dynamicly and therefore can't be managed in the way you describe.
You can control how they are created by the tablespace's default storage (init/next extents and pct inc). I suspect the increasing size of the requested extension is a function of percent increase and how far your query has progressed and it's competition with other processes for temporary space.
Depending on the version you're on you might suggest the DBA look at making the tablespace a "temporary" tablespace. This is different than making it a user's temporary tablespace in that it modifies the way oracle manages physical space.
Ken F.
hchen_at_cc.memphis.edu wrote in article
<1997Dec30.191027_at_latte.memphis.edu>...
> I was running a big query again Oracle 7.3.3 at NT server. I got error
message
> says:
>
> "ORA-01652: unable to extend temp segment by 315 in tablespace SELMC"
> *SELMC is the name of tablespace.
>
> I told the DBA and he increased the segment space for me. I run the same
query
> again, I got the same error, but it said unable to extend temp segment by
417.
> Then the DBA drop the old segment and created new temp segment with
bigger
> size, but when I run the query again, I still got the same error code and
now
> it said unable to extend temp segment by 1595. Then I tried disconnect to
the
> database and then run the same query, unfortunately, I still got the same
error
> code and now it is said unable to extend temp segment by 5120!
>
> Our tablespace is 175 meg, and used up 82 meg. The roll-up segment is 30
meg.
> There are about 90,000 records in the fact table.
>
> My questions are:
> 1. 1.How to deal with this error code?
> 2. 2.Why I still get the same error after the DBA increased the space?
> 3. 3.Why the unable to extend temp space become bigger and bigger after
each
> query?
>
> I am new to Oracle, Please help. Any suggestion are welcome and
appreciated!
> You can either reply this mail or send reply to mchen_at_netbasecomp.com.
> Thank you!
>
> Mary Chen.
>
>
Received on Wed Dec 31 1997 - 00:00:00 CST