Re: Odd ora-1652

Dear Barbara,

Thanks for your help.

I did specify the extent size to 256k. Does Oracle still need to find a 1g contiguous space for this table.
The tablespace is locally management which has the uniform size 64k.

Thanks,

Barbara Kennedy <barbken_at_teleport.com> wrote in message news:BgFW5.153$V4.169810_at_nntp3.onemain.com...
> 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 Mon Dec 04 2000 - 00:38:33 CST