-- 创建临时表空间
create temporary tablespace hrx_temp_data
tempfile '/home/oracle/hrx_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

--创建表空间
create tablespace hrx_data
logging
datafile '/home/oracle/hrx_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

/*第3步：创建用户并指定表空间 */
create user hrx identified by hrx
default tablespace hrx_data
temporary tablespace hrx_temp;

/*第4步：给用户授予权限 */
grant connect,resource,dba to hrx;