Re: Unable to extend temp on non temp tablespace

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Mon, 06 Jan 2003 23:58:26 +0100
Message-ID: <cd1k1vsidn7o8poqiauoq9j42ot6vd83au@4ax.com>

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote:

>Hi Rick,
>
>one other thing - do any of the indexes in question have PCTINCREASE set
>on them ?

No. PCTINCREASE is set to zero. But you did not miss the point too far. In fact, the problem was identified as being caused by unsuitable storage parameters. The initial extent was set to high, so while rebuilding the index, at least as much space in a chunk would be needed. Probably, the index was rebuild in the past using the compress option.

Thanks
Rick Denoire Received on Mon Jan 06 2003 - 16:58:26 CST