Creating the SYSAUX Tablespace (72)

The SYSAUX tablespace is always created at database creation. The SYSAUX tablespace
serves as an auxiliary tablespace to the SYSTEM tablespace. Because it is the default
tablespace for many Oracle Database features and products that previously required
their own tablespaces, it reduces the number of tablespaces required by the database
and that you must maintain. Other functionality or features that previously used the
SYSTEM tablespace can now use the SYSAUX tablespace, thus reducing the load on the
SYSTEM tablespace.

You can specify only datafile attributes for the SYSAUX tablespace, using the SYSAUX
DATAFILE clause in the CREATE DATABASE statement. Mandatory attributes of the
SYSAUX tablespace are set by Oracle Database and include:
■ PERMANENT
■ READ WRITE
■ EXTENT MANAGMENT LOCAL
■ SEGMENT SPACE MANAGMENT AUTO

You cannot alter these attributes with an ALTER TABLESPACE statement, and any
attempt to do so will result in an error. You cannot drop or rename the SYSAUX
tablespace.

If you include a DATAFILE clause for the SYSTEM tablespace, then you must specify
the SYSAUX DATAFILE clause as well, or the CREATE DATABASE statement will fail.

If you issue the CREATE DATABASE statement with no other clauses, then the software
creates a default database with datafiles for the SYSTEM and SYSAUX tablespaces
stored in system-determined default locations, or where specified by an
Oracle-managed files initialization parameter.
The SYSAUX tablespace has the same security attributes as the SYSTEM tablespace.

建立SYSAUX表空間
1. SYSAUX中是很多Oracle特性與產品安裝時的預設表空間 , 可減少system表空間的負載
2. 只能為SYSAUX指定datafile屬性 , 其他的如 永久性 , 可讀寫 , 本地管理 ,
assm都是由Oracle指定的
3. 對SYSAUX表空間不能使用alter tablespace語句 , 也不能刪除,重新命名該表空間
4. 如果為system表空間使用了datafile子句 , 則也需要為sysaux指定datafie子句

[@more@]