创建表空间和用户

• oracle em地址：

http://127.0.0.1:1158/em

• 创建临时表空间

create temporary tablespace sfsj_temp  
tempfile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize unlimited  
extent management local;  

• 创建数据表空间

create tablespace sfsj_data  
logging  
datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize unlimited  
extent management local;

• 创建用户并指定表空间

create user sfsj identified by sfsj  
default tablespace sfsj_data  
temporary tablespace sfsj_temp;  

• 给用户授予权限

grant connect,resource,dba to sfsj;

• 增加表空间大小

alter tablespace sfsj_data add datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data02.dbf'
size 200M
autoextend on  
next 50m maxsize unlimited;

• 删除表空间文件

alter tablespace sfsj_data drop datafile 'C:\oracle\product\10.2.0\oradata\orcl\sfsj_data02.dbf';

• 查看表空间数据文件位置

select t1.name,t2.name 
         from v$tablespace t1,v$datafile t2
         where t1.ts# = t2.ts#;