创建用户和表空间

create tablespace itsvdb
logging
datafile 'F:\oracle\product\10.2.0\oradata\orcl\itsvdb.dbf' 
size 512m 
autoextend on 
next 32m maxsize 1024m
extent management local;
--创建用户并指定表空间
create user itsvdb_risen2016 identified by admin
default tablespace itsvdb
--给用户授予权限
grant connect,resource,dba to itsvdb_risen;