Re: Sorting data in Oracle tables

Sushama Belkhode wrote:
>
> 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.

See if this works. Create a duplicate but empty table and the required index on the column(s). Populate the new table from the old. I wouldn't think that this would require a large temp area. If everything works out, you can drop the old table and rename the new one.

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"