Re: Reorganizing SYSTEM tablespace

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 22 May 2002 20:32:46 GMT
Message-ID: <3CEC0060.4BC3D433@exesolutions.com>

RSH wrote:

> What WOULD be a good reason?
>
> I used to give OEM space in SYSTEM and as soon as I realized the
> ridiculousness of that, I stopped that.
>
> Of course the data dictionary and PL/SQL and such take up space there, but
> indirectly so to speak. SQL*PLUS's help tables and such are shoved in TOOLS.
>
> What legitimately does belong there, apart from Oracle internal objects?
>
> RSH.
>
> "David Fitzjarrell" <oratune_at_msn.com> wrote in message
> news:32d39fb1.0205221046.1b2888ae_at_posting.google.com...
> > "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> > > ... No real user should ever have quota on SYSTEM, except on a case by
> case basis.
> > >
> > > Regards
> > > HJR
> > >
> >
> > Boy, it had BETTER be a DAMN GOOD REASON for a real user to have ANY
> > quota on SYSTEM.

The only thing I can think of is a verify password function and any objects associated with it.

Daniel Morgan Received on Wed May 22 2002 - 15:32:46 CDT