The SYSAUX Tablespace (40)

最新推荐文章于 2025-12-18 10:59:28 发布

转载最新推荐文章于 2025-12-18 10:59:28 发布 · 92 阅读

文章标签：

#数据库

本文介绍了Oracle数据库中的SYSAUX表空间，它是SYSTEM表空间的辅助存储区域，在数据库创建或升级时自动生成。SYSAUX用于存放不在SYSTEM表空间内的数据库元数据，并且不能进行删除或重命名操作。

The SYSAUX tablespace is an auxiliary tablespace to the SYSTEM tablespace. Many
database components use the SYSAUX tablespace as their default location to store data.
Therefore, the SYSAUX tablespace is always created during database creation or
database upgrade.
The SYSAUX tablespace provides a centralized location for database metadata that
does not reside in the SYSTEM tablespace. It reduces the number of tablespaces created
by default, both in the seed database and in user-defined databases.
During normal database operation, the Oracle database server does not allow the
SYSAUX tablespace to be dropped or renamed. Transportable tablespaces for SYSAUX
is not supported.
Note: If the SYSAUX tablespace is unavailable, such as due to a
media failure, then some database features might fail.

1. SYSAUX(system+auxiliary)是system的辅助表空间
2. 在数据库创建或升级时该表空间被创建
3. 元数据的集中地
4. 不允许删除，重命名，不支持可传输

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-972493/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-972493/