[Oracle] oracle11数据库安装图文教程

create tablespace liyuanDb_data 
logging 
datafile 'D:\soft\oracle\tablespaceData\liyuanDb_data01.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local;
--创建临时表空间 
create temporary tablespace liyuanDb_temp 
tempfile 'D:\soft\oracle\tablespaceData\liyuanDb_temp01.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local;
--创建用户并指定表空间 
create user ly identified by 123 
default tablespace liyuanDb_data 
temporary tablespace liyuanDb_temp;
--给予权限
grant connect,resource to ly;
--撤销权限
revoke connect,resource from ly;