DB, Storage/oracle

system and sysaux tablespaces

卽興詩人 2013. 11. 20. 09:45

* system, sysaux table spaces are mandatory tablespaces the are created at the time of database creation.

they must be online


* SYSTEM tablespace is used for core functionality (dictionary tables)


* the auxiliary SYSAUX tablespace is used for additonal database components ( such as the enterprise manager repository)


* the system and sysaux tablespaces are not recommended to be used to store application's data.