ITPub博客

首页 > 应用开发 > IT综合 > The SYSAUX Tablespace (40)

The SYSAUX Tablespace (40)

原创 IT综合 作者:tsinglee 时间:2007-09-26 15:28:43 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Undo tablespaces (41)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1930081