Re: rebuild tablespace HELP ORA 01652

Hi Scot,

What basically happens in creating indexes is first there is a sort in the temp segment (in the tablespace designated in the temporary tablespace of the user), then the index is being created as a temporary segment in the destination tablespace.
When creation is complete that segment is being renamed. You could easily monitor this (assuming the action will not complete in a few secs) by issuing

select segment_name, tablespace_name, extents, bytes/1024 k from dba_segments
where segment_type = 'TEMPORARY'

Your error message means you don't have enough CONTIGUOUS free space in the destination tablespace.
You could try to resolve this by alter tablespace GADGET_IDX coalesce.

Hth,

Sybrand Bakker, Oracle DBA

Scot Needy <scotrn_at_pilot.infi.net> wrote in message news:8E1B675D0sneedyinfinet_at_news.infi.net...
>
> Hi;
>
> Can someone help me understand what this statement does to
> what tablespaces ? I have 1Gb GADGET_IDX tablespace but it is
> only using 361Mb of it, according to Storage Mgr. So why doesnt it have
> enough space? Or does this indicate I need to extend my TEMP tablespace?
>
> Thanks
> Scot
>
> -------------------------------------------------------------------
> alter index ADD.XPKAG_SCHEDULE1 rebuild tablespace GADGET_IDX
> *
> ERROR at line 1:
> ORA-01652: unable to extend temp segment by 23929 in tablespace GADGET_IDX
>
Received on Sat Aug 07 1999 - 11:15:52 CDT