Re: SYSTEM and SYSAUX Tablespace Opinions Requested

-----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-----
.

Relevant Pages