表空间操作

数据库使用：创建表空间和用户
CREATE TABLESPACE sersrv_tblspace DATAFILE '/opt/oracle/srv520/sersrv_tbl.dbf' SIZE 10000M reuse autoextend on maxsize 10000M;

CREATE TEMPORARY TABLESPACE sersrv_tmpspace tempfile '/opt/oracle/srv520/sersrv_tmp.dbf' SIZE 20M;

create user sersrv identified by sersrv default tablespace sersrv_tblspace temporary tablespace sersrv_tmpspace profile default;

grant dba to sersrv;

数据库使用：删除表空间
drop tablespace portal1_tblspace INCLUDING CONTENTS;

数据库使用：删除没有对应datafile的表空间
alter database datafile '/home3/datafile/arrange/NewArrange.dbf' offline drop;
drop tablespace ××××;