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 10Mautoextend on next 100Mmaxsize 500M,'/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'size 10Mautoextend on next 100Mmaxsize 500M ;

增加数据文件

ALTER TABLESPACE game

ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;