删除用户
drop user wsjgxt cascade;
DROP TABLESPACE wsjgxt_data INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE wsjgxt_tmp INCLUDING CONTENTS AND DATAFILES;
创建表空间
create tablespace hz7sp2_data datafile 'D:\app\Administrator\oradata\orcl\hz7sp2_data.dbf'
size 100m autoextend on next 32m maxsize 2048m;
创建临时表空间
create temporary tablespace hz7sp2_tmp tempfile 'D:\app\Administrator\oradata\orcl\hz7sp2_tmp.dbf'
size 100m autoextend on next 32m maxsize 2048m;
创建用户
CREATE USER hz7sp2 IDENTIFIED BY hz7sp2 DEFAULT TABLESPACE hz7sp2_data TEMPORARY TABLESPACE hz7sp2_tmp ;
授权
grant DBA,CREATE SESSION ,UNLIMITED TABLESPACE,CREATE VIEW,SELECT ANY TABLE,SELECT ANY DICTIONARY to hz7sp2 ;
grant CREATE ANY PROCEDURE,CREATE ANY SEQUENCE,CREATE ANY TABLE to hz7sp2 with admin option;