From: swap@programmer.net (swap)
Newsgroups: comp.databases.oracle
Subject: Re: SYS overload
Date: 11 Nov 2002 07:37:01 -0800
Organization: http://groups.google.com/
Lines: 14
Message-ID: <2a0ec6d2.0211110737.20ba3223@posting.google.com>
References: <5ed566f1.0211102121.41965a1a@posting.google.com>
NNTP-Posting-Host: 194.185.74.126
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1037029022 31226 127.0.0.1 (11 Nov 2002 15:37:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 11 Nov 2002 15:37:02 GMT


I suppose that it will not be a fatal error. You will not be able to
do some DDL commands (SYS is owner of catalog tables that are stored
on system tablespace). I think you should change "next extent" size or
resize/add file linked to SYSTEM tablespace.

Ciao
Swap

turin78@mail.ru (Eugene Turin) wrote in message news:<5ed566f1.0211102121.41965a1a@posting.google.com>...
> I have Oracle 7.
> One of my table in tablespace SYS has next extent size more than free
> space in tablespace. Fortunetly this table is not growing for now.
> What will happening if oracle try to extent the table and tablespace
> SYS will overload? It will be a fatal to database?