创建表空间
create tablespace EPMP_data
datafile 'D:\app\ys\product\11.2.0\dbhome_1\epmps.dbf'
size 50M
autoextend on next 5M maxsize 3000M;
创建用户并指定表空间
create user xxx identified by xxx
default tablespace EPMP_data
给用户赋权限
grant connect ,resource,dba to xxx;
删除表空间
drop tablespace EPMP_data INCLUDING CONTENTS AND DATAFILES;
重新给用户指定表空间
alter user EPMP_DIM default tablespace EPMP_Data;