1、創(chuàng)建表空間

create tablespace TEST?

logging

datafile 'e:\app\administrator\oradata\orcl\TEST.dbf'

size 100M

autoextend onnext 100M maxsize 4096Mextent management local;

2、創(chuàng)建用戶并指定表空間

create use testuser identified by password

default tablespace TEST

temporary tablespace temp;

3、授權(quán)

grant connect to testuser;

grant dba to testuser;

grant role to testuser;