会议系统

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

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

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

 

转载于:https://www.cnblogs.com/Jeely/p/11089902.html