Sorting data in Oracle tables

From: Sushama Belkhode <sbelk_at_nctrf.nf.ca>
Date: 1997/07/22
Message-ID: <33D4C84B.31C9@nctrf.nf.ca>#1/1

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 Tue Jul 22 1997 - 00:00:00 CDT