1. 创建临时表空间    
create temporary tablespace documentTEMP tempfile 'D:/app/oradata/orcl/documentTEMP.dbf' 
size 500m   
autoextend on next 100m  
maxsize 10240m  
extent management local;  
 
2. 创建数据表空间    
create tablespace documentmain datafile 'D:/app/oradata/orcl/documentmain.dbf'  
size 500M 
autoextend on next 50M   
maxsize unlimited  
extent management local;  

3.创建用户并制定临时表空间和默认表空间    
create user documentuser identified by documentuser
default tablespace documentmain
temporary tablespace documentTEMP;

4.给用户授予权限  
 grant connect,resource,dba to documentuser;