[Q]关于locally management tablespace

显示全部楼层 · 2005-10-30 17:05:33

我在机工的书上看到：
permanet tablespace in oracle 9i,default state is locally management autoallocate ,but temporary tablespace's default state is dictionary management ,and if you create a temporary tablespace use 'extent management local',it's default state is uniform！？
I can't find any explanation about that from SG！
is that true？？
thanks！

千问 · 2005-10-30 17:05:33

使用createtemporary tablespace temp
tempfile '/disk2/oradata/mydb/tmp.dbf' size 500m
创建的是local managed,
而使用create tablespace temp
datafile '/disk2/oradata/mydb/tmp.dbf' size 500m
创建的才是dictionary managed,
前者是9i新引入的想必更优秀

千问 · 2005-10-30 17:05:33

9i default create tablespace temp datafile .....
這樣是local managed ，不是dictionary managed 了！~~~

千问 · 2005-10-30 17:05:33

谢谢各位！
我在数据库里试过乐

使用create temporary tablespace temp
tempfile '/disk2/oradata/mydb/tmp.dbf' size 500m
创建的是local managed, uniform
而使用create tablespace temp
datafile '/disk2/oradata/mydb/tmp.dbf' size 500m
创建的是local managed,autoallocate