oracle 数据库创建表空间和用户

---------- 创建临时表空间

create temporary tablespace esb_temp 

tempfile 'D:\app\oracledata\esb_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  

extent management local;  

------------创建表空间

create tablespace esb_data  
logging  
datafile 'D:\app\oracledata\esb_data.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

----------创建用户

create user esb identified by esb  
default tablespace esb_data  
temporary tablespace esb_temp;

------------给用户授权
grant dba to esb;