Re: Deep meaning of error 3232

From: Seb <sebastienNO-louchart_at_wanadooSPAM.fr>
Date: Sat, 3 Jul 2004 11:43:22 +0200
Message-ID: <cc5v3b$mru$1@news-reader5.wanadoo.fr>

"Mark D Powell" <Mark.Powell_at_eds.com> a écrit dans le message de news:2687bb95.0407021548.152aaa99_at_posting.google.com...
> "SL" <no.spam_at_thank.u> wrote in message
news:<cc3u2a$cf2_at_news.rd.francetelecom.fr>... [snip]
>
> Increase the next extent size of your temp tablespace such that it is
> larger than the hash area size being requested. if you are using a
> dictionary managed temp or create tablespace temp temporary the set
> pctincrease = 0, and initial = next = 1M. (This might be Windows NT
> bug 2898249)

Thank you for your reply.
My TS is a LMT (uniform extent size of 256K) so no way to modify its NEXT :-(
I'll use Jonathan's solution with hint for that query because I'm pretty sure this one causes so much trouble.

-- 
SL

Received on Sat Jul 03 2004 - 04:43:22 CDT