ORACLE创建表空间和用户的基础东西

/**创建表空间**/
#数据表空间
create tablespace sw_data 
logging 
datafile 'D:\oracledata\sw_data.dbf' 
size 100m 
autoextend on 
next 20m maxsize 2048m 
extent management local;

#临时表空间
create temporary tablespace sw_temp  
tempfile 'D:\oracledata\sw_temp.dbf' 
size 50m  
autoextend on  
next 20m maxsize 1024m  
extent management local;

/**创建用户并指定表空间**/
create user swmis identified by swmis 
default tablespace sw_data 
temporary tablespace sw_temp;

#DROP USER swmis CASCADE;

/**给用户授权**/
grant connect,resource to swmis;
grant create session to swmis;
grant create table,create view,create trigger, create sequence,create procedure to swmis;
grant unlimited tablespace to swmis;