The SYSAUX Tablespace (40)

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@]