Re: index creation fails because temp tablespace is too small

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 27 Apr 2005 10:21:26 -0500
Message-ID: <gabv61pdfs0cj44mu18hm86e81stmf4jo6@4ax.com>

karelje007_at_ftd.nl (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

Mainly by trial and error..
Or set the temp tablespace to autoextend ( set a max is disk space is an issue) or create a new tablespace with autoextend for indexes to use..

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Wed Apr 27 2005 - 10:21:26 CDT