Re: Sorting data in Oracle tables

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
>
  Received on Thu Jul 24 1997 - 00:00:00 CDT