Re: SYSTEM and SYSAUX Tablespace Opinions Requested

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 12 Sep 2007 20:07:06 +0200
Message-ID: <fc99s3$k96$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DA Morgan wrote:
>

>> So, why would there be problem in loading objects
>> into SYSAUX?

>
> I can't say that there is just as I've seen a lot of production
> databases with stuff in SYSTEM.

Which is wrong, in my opinion. As said before, but snipped. And this is about SYSAUX, not SYSTEM (although I acknowledge SYSAUX being the "offloader" tablespace for SYSTEM)

What I am saying is that it is
> likely a disaster waiting to happen and could make work with
> backups and Flashback and Recyclebin problematic as you could
> inadvertently affect required objects.

I'm talking objects in a tablespace (quota on tablespace...), not object grants.

I'll take your answer as "there's no objection against issuing quota to users on SYSAUX"
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG6CrKLw8L4IAs830RAviqAJ9QsNfdR2kvEIQX9SRkZ2AXDoQJbACfe7jV PTO8Rq/eYr3oFX++x8UAXdA=
=3k5I
-----END PGP SIGNATURE----- Received on Wed Sep 12 2007 - 13:07:06 CDT