新建表空间及用户

登录：sqlplus / as sysdba
注意，斜杆左右有空格
1、新建表空间

create tablespace gxzz datafile 'C:\oracledata\gxzz.dbf' size 1G autoextend on next 10M MAXSIZE UNLIMITED;
2、新建用户

create user gxzz identified by gxzz default tablespace gxzz;
grant connect,resource to gxzz;
grant dba to gxzz;