Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Quoting from Oracle documentation about logical storage structures:

A database must have the SYSTEM and SYSAUX tablespaces:

alt text

Why is it compulsory to have these tablespaces?

share|improve this question

1 Answer 1

up vote 10 down vote accepted

Tradition and the ability for elegant failure degradation.

As the database has evolved over 11 versions, important views and tables that maintain and support the database have been programmed into the two tablespaces. Furthermore, they represent a fantastic logical separation between the "NEVER EVER TOUCH" and the "third parties can put stuff here."

From the docs:

The SYSAUX tablespace was installed as an auxiliary tablespace to the SYSTEM tablespace when you created your database. Some database components that formerly created and used separate tablespaces now occupy the SYSAUX tablespace.

If the SYSAUX tablespace becomes unavailable, core database functionality will remain operational. The database features that use the SYSAUX tablespace could fail, or function with limited capability.

Thus, while it's critical to have the SYSTEM tablespace never ever fail, one doesn't need to be nearly as paranoid for SYSAUX, this allows the designers to keep the size of SYSTEM down, while allowing third-party auxiliary features to be part of the "core" database.

share|improve this answer
    
So the same reason why Microsoft includes so much stuff in Windows. :p ... This is also why some people complain about the cruft of Oracle, and you can't get away from those complaints on any system, more or less. –  jcolebrand Jan 11 '11 at 16:18
    
That, and it's handy to have a "miscellaneous" area that has all your third-party stuff that... if it has an accident... won't nuke anything else. –  Brian Ballsun-Stanton Jan 12 '11 at 0:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.