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.