Path: news.easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: srivenu@hotmail.com (srivenu)
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-1650 error
Date: 8 Aug 2002 21:07:49 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <1a68177.0208082007.7a6a3add@posting.google.com>
References: <abbcb3d7.0208071633.4a44cdf6@posting.google.com> <aiseku$d4h$1@lust.ihug.co.nz>
NNTP-Posting-Host: 203.196.224.146
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1028866069 13401 127.0.0.1 (9 Aug 2002 04:07:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Aug 2002 04:07:49 GMT
Xref: easynews comp.databases.oracle.server:157326
X-Received-Date: Thu, 08 Aug 2002 21:04:53 MST (news.easynews.com)

If you have sufficient space in the file system, Set the AUTO EXTEND
property
of the datafile's in the tablespace's to ON.
ex- ALTER TABLESPACE DATAFILE 'xxxxxx' AUTOEXTEND ON MAXSIZE xxxx;
Hope your rollback segments are all in the same tablespace;

I would prefer to set a specific ROLLBACK SEGMENT for the big
transaction and  set only that tablespaces datafiles to AUTOEXTEND.

By the way are all the ROLLBACK tablespaces spread across different
disks or are they on one single disk ?
If you have all of them on one disk, i would prefer to have a single
ROLLBACK tablespace instead of 4.