Unable to extend temp on non temp tablespace

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 7 Jan 2003 09:20:01 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7032172D0@lnewton.leeds.lfs.co.uk>

Hi Rick,

glad you got there in the end !

<RANT>
I loath and detest people who insist on using (or defaulting) COMPRESS=YES on exports - they cause so many problems later on. </RANT>

:o)

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Rick Denoire [mailto:100.17706_at_germanynet.de] Posted At: Monday, January 06, 2003 10:58 PM Posted To: server
Conversation: Unable to extend temp on non temp tablespace Subject: Re: Unable to extend temp on non temp tablespace

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 Tue Jan 07 2003 - 03:20:01 CST