//创建表空间 datafile后面是要存放的路径
create tablespace TEST
datafile 'D:/app/40276/oradata/orcl/TEST'
size 1M autoextend on next 50M maxsize unlimited;
//创建用户 identified by后面是密码
create user TEST
identified by "root"
default tablespace TEST
profile DEFAULT
ACCOUNT UNLOCK;
//授权
grant dba to TEST;
grant unlimited tablespace to TEST;
在sys用户下