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

1、创建临时表空间

create temporary tablespace epa_temp  

tempfile 'D:\app\oracle_tablespace\epa_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m      -- MASIZE UNLIMITED
extent management local;  

2、创建表空间

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

3、创建用户并分配表空间
create user epa identified by Zhou1234  
default tablespace epa_data  
temporary tablespace epa_temp;  

4、用户授权
grant connect,resource,dba to epa;