Re: Sorting data in Oracle tables

try --
While the DBA is away you can create your own tablespace for the index. create the index in that tablespace and off you go. When the DBA gets back he/she can just trash your tablespace and fix the one where the Indexes belong.

Good luck

diversif wrote:

> Did you try 'upping' the default 'NEXT' value for the tablespace xyz.
> This
> should fix it.
> Also, if you are at 7.3?? there is a 'NOSORT' option on the create
> index
> stmnt. If the data in the column is already sorted (prior to load),
> you
> can specify this option and the sort will be bypassed.
>
> Sushama Belkhode <sbelk_at_nctrf.nf.ca> wrote in article
> <33D4C84B.31C9_at_nctrf.nf.ca>...
> > I have a table with over 1 million records. Any attempt to create an
 

> > index results in
> >
> > ORA-01630 max# of extents 121 reached in temp segment in
> > tablespace xyz.
> > Action: If possible increase values of MAXEXTENTS or PCTINCREASE
 

> > or make changes to storage parameters.
> >
> > I cannot do any of the above as my DBA is away. If I can sort my
 data
> > then I can bypass the sort phase of creating an index (which uses
> > temporary segments) using the NOSORT option.
> >
> > Any suggestions on how to do this? Right now I cannot even use an
 order
> > by clause in my select statement.
> >
> > Thanks in advance
> >
> > Sushama
> >

--
eric kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html