Re: index creation fails because temp tablespace is too small

karel wrote:

> Hi,
>
> i have a problem. I'm enabling a unique constraint, that is
> creating a index on a table. The table contains 135000000 rows
> ( 13 GB)
> my temp tablespace is 3 gb big.
>
> when i enable the constraint it keeps failing because the temp
> tablespace is to small.
>
> is there a workaround for this issue and how big must temp be
> when it wil enable succesfully.
>
> thx
> michel

You've already got good advice if on Standard Edition but if on Enterprise Edition look at the partitioning option and the use of local indexes.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)