Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Odd ora-1652
You have to have 1 gig of contiguous space available to allocate a 1 gig
table in one extent. If you had 10 250 meg extents with a 8K extent (with
data) between each of those you could not allocate 1 extent of 1 gig.
This might be the problem.
Jim
"Chuan Zhang" <chuan_at_asiaonline.net> wrote in message
news:JZBW5.7$u27.346205_at_news.interact.net.au...
> Hi, All,
>
> I have got the ora-1652 error.
> "Sun Dec 3 03:04:42 2000
> ORA-1652: unable to extend temp segment by 8192 in tablespace
> PIN00
> Sun Dec 3 03:17:28 2000
> ORA-1652: unable to extend temp segment by 1024 in tablespace
> PIN00"
>
> This error happened when we refreshed our DB nightly by creating the
tables
> copied from another DB. I have checked the tablespace "PIN00", there are
> almost 3GB free space left. The table being created is only 1GB big. I
> checked temporary tablespace as well, there is 2Gb free space. By the way,
> the PIN00 tablespace is locally management tablespace.
>
> On both table and tablespace level, specify the maxextents unlimited.
>
> I have no idea what's wrong with this error. Can anybody have this
> experience before? It is on Solaris 2.7 and Oracle 8.1.5.
>
> Your help is much appreciated.
>
> Thanks in advance,
>
> Chuan
>
>
>
>
Received on Sun Dec 03 2000 - 22:39:42 CST