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;
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;