Unable to extend temp on non temp tablespace

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 6 Jan 2003 12:56:30 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703200521@lnewton.leeds.lfs.co.uk>

Hi Rick,

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

I've had this problem in the past where a dump imported from a customer had 50% PCTINCREASE and this led to some 'interesting' failures to get space.

Just a thought.

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: Sunday, January 05, 2003 10:53 PM Posted To: server
Conversation: Unable to extend temp on non temp tablespace Subject: Unable to extend temp on non temp tablespace

Hello

In the past weeks I am getting following message in the alert.log:

ORA-1652: unable to extend temp segment by 131072 in tablespace ALL_INDEX <SNIP> Received on Mon Jan 06 2003 - 06:56:30 CST