创建表空间:
create [undo|TEMPORARY]tablespace venn datafile '/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn01.dbf'size 10Mautoextend on next 100Mmaxsize 500M [unlimited] --最大32Glogging online permanent; --一直在线
添加数据文件:
alter tablespace venn add datafile '/opt/oracle/db01/app/oracle/oradata/OSSORCL/venn02.dbf'size 10Mautoextend on next 100Mmaxsize 500M ;
同时添加多个文件:
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 ;
删除表空间:
drop tablespace venn including contents and datafiles;
同时删除内容和数据库文件。
联系客服