1,创建表空间
create tablespace XXX
logging
datafile ‘D:\app\Administrator\oradata\orcl\XXX.dbf’ (datafile目录)
size 50m
autoextend on
next 50m maxsize 20480m ;
2.创建用户
create user User
identified by User
default tablespace XXX
temporary tablespace temp; (用默认的临时表空间就行)
3.授权
grant connect,resource,dba to ULTRABPP_TK;