//创建表空间
create tablespace TYKJ_PRO
logging
datafile'D:\oracle\oradata\TYKJ_PRO\TYKJ_PRO.dbf'
size 1G
autoextend on
next 10m
extent management local
/
//创建临时表空间
CREATE temporary TABLESPACE TYKJ_PRO_temp
tempfile'D:\oracle\oradata\TYKJ_PRO\TYKJ_PRO_temp.dbf'
size 1G
autoextend on next 10M
extent management local
/
//创建用户
create user xxxtest
identified by xxxtest
default tablespace TYKJ_PRO
temporary tablespace TYKJ_PRO_temp
/
//赋予权限
grant dba,create view,connect,resource to xxxtest