Oracle创建表空间

1 create tablespace db_name_ 2 datafile 'D:\oracle\product\10.2.0\oradata\orcl\db_name_.dbf' size 200M 3 autoextend on next 10M maxsize unlimited logging 4 extent management local autoallocate 5 segment space management auto;   -- 创建JYGISDATA表空间 CREATE SMALLFILE TABLESPACE "JYGISDATA" DATAFILE 'E:\DATABASE\JYGISDATA1.DBF' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED , 'E:\DATABASE\JYGISDATA2.DBF' SIZE 500M AUTOEXTEND ON NEXT 500M , 'E:\DATABASE\JYGISDATA3.DBF' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO   http://zhidao.baidu.com/question/260880600.html