extent management dictionary/local

liukai_happy 2010-05-01 10:51:26

create tablespace jinlian
datafile 'h:\tablespace\jinlian.dbf' size 10m
minimum extent 50k
extent management dictionary
default storage( initial 50k next 50k maxextents 100 pctincrease 0)
/

创建数据字典管理表空间失败！google了一下发现说
ORA-12913: Cannot create dictionary managed tablespace
Cause: Attemp to create dictionary managed tablespace in database which has system tablespace as locally managed

Action: Create a locally managed tablespace.

system表空间时local管理的所以创建数据字典管理表空间失败

但是我查了一下官方文档说

You cannot specify DICTIONARY if the SYSTEM tablespace of the database is locally managed or if you have specified the temporary_tablespace_clause.
你不能描述一个数据字典管理表空间如果你的system 时local管理的时候或者你想要创建一个临时表空间

If you do not specify the extent_management_clause, then Oracle Database interprets the MINIMUM EXTENT clause and the DEFAULT storage_clause to determine extent management

If you do not specify the DEFAULT storage_clause, then the database creates a locally managed autoallocated tablespace

如果你不描述 default 存储设置时数据库将创建local管理的表空间

If you did specify the DEFAULT storage_clause, then:

If you specified the MINIMUM EXTENT clause, then the database evaluates whether the values of MINIMUM EXTENT, INITIAL, and NEXT are equal and the value of PCTINCREASE is 0. If they are equal, then the database creates a locally managed uniform tablespace with extent size = INITIAL. If the MINIMUM EXTENT, INITIAL, and NEXT parameters are not equal, or if PCTINCREASE is not 0, then the database ignores any extent storage parameters you may specify and creates a locally managed, autoallocated tablespace.

If you did not specify MINIMUM EXTENT clause, then the database evaluates only whether the storage values of INITIAL and NEXT are equal and PCTINCREASE is 0. If they are equal, then the tablespace is locally managed and uniform. Otherwise, the tablespace is locally managed and autoallocated.

Restrictions on Extent Management

Extent management is subject to the following restrictions:

A permanent locally managed tablespace can contain only permanent objects. If you need a locally managed tablespace to store temporary objects, for example, if you will assign it as a user's temporary tablespace, then use the temporary_tablespace_clause.

If you specify LOCAL, then you cannot specify DEFAULT storage_clause, MINIMUM EXTENT, or the temporary_tablespace_clause ------------重点

我的理解是如果设置default storage 的话那么就可以创建extent management dictionary 否则就不行。

请问问时这样的么

如果不是

那么想创建extent management dictionary 该如何。

...全文