Re: index creation fails because temp tablespace is too small

Assuming it's a simple heap table, and most rows will appear in the index.

For each column in the index, find the average data size, and add two Sum the results
Add 12 to the total
Round up to a multiple of 4
Multiply by the number of rows in the table.

That's a ball park figure for the TEMP you will need.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






"karel" <karelje007_at_ftd.nl> wrote in message 
news:426fa9d5$0$24221$ba620dc5_at_nova.planet.nl...


> 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

>