创建表空间：

create tablespace tablespace_name

datafile '存放dbf文件的路径'

size 20M

autoextend on next 10M maxsize unlimited;

创建用户分配表空间：

create user user_name

identified by password

default tablespace tablespace_name;

temporary tablespace tablespace_name;

分配权限，删除权限：

grant priviliges or role to user_name

revoke priviliges or role from user_name

grant connect,resource to user_name;

revoke resource from user_name;