Re: SYS overload
From: swap <swap_at_programmer.net>
Date: 11 Nov 2002 07:37:01 -0800
Message-ID: <2a0ec6d2.0211110737.20ba3223_at_posting.google.com>
Date: 11 Nov 2002 07:37:01 -0800
Message-ID: <2a0ec6d2.0211110737.20ba3223_at_posting.google.com>
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_at_mail.ru (Eugene Turin) wrote in message news:<5ed566f1.0211102121.41965a1a_at_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?
Received on Mon Nov 11 2002 - 16:37:01 CET