Oracle表空间创建的sql

1. 创建表空间
create tablespace SIRM2 
datafile 'D:\oracle\product\10.2.0\oradata\orcl\SIRM2.dbf'

size 1024M --存储地址 初始大小1G
autoextend on next 10M --每次扩展10M

--maxsize 2024M  --

maxsize unlimited --无限制扩展

EXTENT MANAGEMENT local  autoallocate
segment space management auto;

 

同时添加多个文件：alter tablespace venn add datafile '/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'

size 10M
autoextend on next 100M
maxsize 500M,
'/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'
size 10M
autoextend on next 100M
maxsize 500M ;

增加数据文件 
ALTER TABLESPACE game 
ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;