创建表空间 用户 分配权限

select * from dba_users where username = 'HEER_DEV';
select * from dba_tablespaces where tablespace_name = 'HEER_DATA';

#上面是测试
create tablespace heer_data
datafile 'C:\oracle\product\10.2.0\oradata\oracle\HEER_DATA.DBF' size 1G
autoextend on next 10m;
#创建表空间
create user heer_dev identified by heerok
default tablespace heer_data quota unlimited on heer_data;
#创建用户
grant connect,resource to heer_dev;

grant create view to heer_dev;
alter user heer_dev default role connect,resource;

#创建权限