Re: Size of temporary tablespace

2 times the sum of the size of all the keys of the largest index.

Hth,

Sybrand Bakker, Oracle DBA

Peter Laursen < ptl_at_edbgruppen.dk> wrote in message news:01bf996c$1671aed0$2c289a0a_at_apollo...
> Hi
>
> What guidelines do you use when estimating the size of the temporary
> tablespace?
>
> I just had an import fail because the size of an index was larger than the
> temp tablespace. (8.0.5 on NT 4.0) So I guess temp should be at least the
> size of the largest index?
>
> tia
> Peter Laursen
Received on Wed Mar 29 2000 - 00:00:00 CST