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‘

<em id="__mceDel">size 10M
autoextend on next 100M
maxsize 500M<strong>,
</strong>‘/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf‘
size 10M
autoextend on next 100M
maxsize 500M ;<br><br>增加数据文件 <br data-filtered="filtered">ALTER TABLESPACE game <br data-filtered="filtered">ADD DATAFILE ‘/oracle/oradata/db/GAME02.dbf‘ SIZE 1000M; <br><br><br><br><br></em>

Oracle表空间创建的sql

标签：datafile   limit   end   sql   toe   sso   file   creat   xtend