1、创建表空间
create tablespace TEST
logging
datafile ‘e:\app\administrator\oradata\orcl\TEST.dbf‘
size 100M
autoextend on
next 100M maxsize 4096M
extent management local;
2、创建用户并指定表空间
create use testuser identified by password
default tablespace TEST
temporary tablespace temp;
3、授权
grant connect to testuser;
grant dba to testuser;
grant role to testuser;