Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!feed.news.nacamar.de!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail
From: Rick Denoire <100.17706@germanynet.de>
Newsgroups: comp.databases.oracle.server
Subject: ORA-1652 with autoextendable tablespace
Date: Sun, 02 Feb 2003 23:46:00 +0100
Organization: T-Online
Lines: 22
Message-ID: <am5r3vs7cocqeldq1o929hrns7edmp0sb8@4ax.com>
Reply-To: 100.17706@germanynet.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.t-online.com 1044225931 02 32190 WpVdE+2XSEARIH 030202 22:45:31
X-Complaints-To: abuse@t-online.com
X-Sender: 320058382570-0001@t-dialin.net
X-Newsreader: Forte Agent 1.7/32.534
Xref: newsfeed1.easynews.com comp.databases.oracle.server:174534
X-Received-Date: Sun, 02 Feb 2003 15:45:21 MST (news.easynews.com)

Why is it that I get "ORA-1652: unable to extend temp segment by 128
in tablespace TEMP" even if I have one file in this tablespace set to
autoextend?

The TEMP tablespace had 3 files 8 GB each when I first got this
message. I reluctantly added one more file with 2 GB initial size,
autoextendable up to 8 GB. But it did not grow a bit. And in my
opinion more than 24 GB for TEMP is huge of the space used for pure
data is comparable in size.

Of course, TEMP seems to be always full, but this is the way Oracle
8.1.7 works: It cleans up space only when necessary, as far as I know.
Now, I will have to prove that the error is coming from a poorly
written application. But since this application was developed by an
external company, I will have to gather rock solid arguments.

So how can I investigate this question? According to my experience,
applications demanding huge amount of space in TEMP are just
erroneous.

Bye
Rick Denoire