create temporary tablespace sdtxhn_temp

tempfile 'E:\app\mrhu\oradata\sdtxorcl\sdtxhn_temp.dbf'

size 50m

autoextend on

next 50m maxsize unlimited

extent management local;

--创建数据表空间

create tablespace sdtxhn_data

logging

datafile 'E:\app\mrhu\oradata\sdtxorcl\sdtxhn_data.dbf'

size 32m

autoextend on

next 32m maxsize unlimited

extent management local; 

-----------------------------------------2.创建用户及给用户授

--权--------------------------------------------------------------

--创建用户并指定表空间

create user hn identified by solution

default tablespace sdtxhn_data

temporary tablespace sdtxhn_temp; 

--给用户授予权限

grant dba to hn;