Re: index creation fails because temp tablespace is too small

Dutch_alien wrote:
>
> Hi Jonathan,
>
> Thx. I appreciate the explanation, and gives me some things to try out.
>
> Most of all, it made me wonder how sort_area_size is related to it.
> (Background: One of my customers is using W2K, and we keep running into
> the 2/3Gb memory limit).
>
> But I think that would be more suitable for a new thread. So I'll be
> doing some testing with unique indexes, constraints and sort_area_size.
> I hope you'll be around to comment on my test results in a week or 2.
>
> Regards,
>
> Arian

go to www.ixora.com.au

Steve has a formula and some explanations about sorting

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------