Re: Reorganizing SYSTEM tablespace

From: RSH <RSH_Oracle_NOSPAM_at_worldnet.att.net>
Date: Wed, 22 May 2002 19:31:22 GMT
Message-ID: <emSG8.36736$Vm2.1881691@bgtnsc04-news.ops.worldnet.att.net>

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.
Received on Wed May 22 2002 - 14:31:22 CDT