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 managementIf 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 该如何。
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 managementIf 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 该如何。
解决方案 »
- Alter Index Allocate Extent 有什么用处?
- ora-28547 错误 用oracle developer 连接 一直报错 试过网上的很多方法 都不行、、高手来
- oracle去重复问题
- 请问,job有命名规则吗?
- 急```如何从游标中将整条数据取出并插入一个表中?
- 请高手指点一下!sql小问题。
- 初学者请教的问题,请大家多多指教。。。
- 急问: 如何读取/写入某个用户对某个表的权限?
- 请问oracle里有类似SQL Server一样的"自动生成SQL脚本"的冬冬吗?
- oracle12c安装过程出现oracle database configutation assistant
- 查询的字段名显示问题
- 菜鸟题问 存储过程 请各位大哥大姐进来看下帮下忙 谢谢
10g 以后不再支持字段管理。
10g Release 2 (10.2)
Part Number B14200-02
版本