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

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

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