先创建表空间
create tablespace "xxDBA" datafile 'xxx.DBF' size 1024 autoextend on next 1024 maxsize 102400 CACHE = NORMAL;
创建用户并赋予一定权限
create user "用户名" identified by "密码"
default tablespace "表空间名字"
default index tablespace "表空间名字";
grant "PUBLIC","RESOURCE","VTI" to "用户名";