[Q] 031 tablespace

显示全部楼层 · 2008-7-17 11:40:34

In a dictionary-managed tablespace, the minimum INITIAL value allowed is 2 times the DB_BLOCK_SIZE parameter. For example, the minimum size allowed for the INITIAL extent for the tablespace is 8K. When the DB_BLOCK_SIZE value for the database is 4K, using 4K for the INITIAL value in a CREATE TABLESPACE statement will return an error
-- from sts
but :
SQL> show parameter db_block_size
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
db_block_size
integer 4096
SQL> create tablespace test1
2datafile 'd:\oracle\oradata\ora9\test1.dbf' size 10m
3extent management dictionary
4default storage ( initial 4k)
5/
表空间已创建。

why?
thanks a lot!

千问 · 2008-7-17 11:40:34

建个表试试，看看实际用了多少。

千问 · 2008-7-17 11:40:34

上面说的应是 create tablespace 会失败, 与create table无关

千问 · 2008-7-17 11:40:34

麻烦说说您的意见

千问 · 2008-7-17 11:40:34

看看dba_tablespaces的参数是多少，再建个表试试，我现在手头没有dictionary manage的数据库，没法做试验。
student guide有不少地方讲的不是很清楚，碰到疑问最好的办法是做试验。

千问 · 2008-7-17 11:40:34

Right. You should try

千问 · 2008-7-17 11:40:34

SQL> l
1create tablespace test1
2datafile 'd:\oracle\oradata\ora9\test1.dbf' size 10m
3extent management dictionary
4* default storage ( initial 4k)
SQL> /
表空间已创建。
SQL> select tablespace_name,block_size,initial_extent
2from dba_tablespaces
3where tablespace_name='TEST1'
4/
TABLESPACE_NAME
BLOCK_SIZE INITIAL_EXTENT
------------------------------ ---------- --------------
TEST1
4096 8192
inital extent is changed to 2*db_block_size, but not return an error
thanks everybody!