Creating a Locally Managed SYSTEM Tablespace (71)

Specify the EXTENT MANAGEMENT LOCAL clause in the CREATE DATABASE statemen
to create a locally managed SYSTEM tablespace. The COMPATIBLE initialization
parameter must be set to 9.2 or higher for this statement to be successful. If you do no
specify the EXTENT MANAGEMENT LOCAL clause, by default the database creates a
dictionary-managed SYSTEM tablespace. Dictionary-managed tablespaces are
deprecated.

A locally managed SYSTEM tablespace has AUTOALLOCATE enabled by default, whic
means that the system determines and controls the number and size of extents. You
may notice an increase in the initial size of objects created in a locally managed
SYSTEM tablespace because of the autoallocate policy. It is not possible to create a
locally managed SYSTEM tablespace and specify UNIFORM extent size.

When you create your database with a locally managed SYSTEM tablespace, ensure
that the following conditions are met:
■ A default temporary tablespace must exist, and that tablespace cannot be the
SYSTEM tablespace.
To meet this condition, you can specify the DEFAULT TEMPORARY TABLESPACE
clause in the CREATE DATABASE statement, or you can omit the clause and let
Oracle Database create the tablespace for you using a default name and in a
default location.
■ You can include the UNDO TABLESPACE clause in the CREATE DATABASE
statement to create a specific undo tablespace. If you omit that clause, Oracle
Database creates a locally managed undo tablespace for you using the default
name and in a default location.

创建本地管理的system表空间
1. 指定extent managment local字句来创建本地管理的system表空间 , COMPATIBLE需设置
为9.2以上
2. 当system为本地管理表空间时 , 不能指定 uniform 子句
3. 指定本地管理的system表空间需要符合以下条件
默认的临时表空间需要存在 , 该表空间不能为SYSTEM表空间
可以指定undo tablespace 子句来创建指定的回滚表空间 , 如果忽略该语句 ,Oracle将用
默认的名称在默认的位置创建本地管理的回滚表空间

[@more@]

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

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