Oracle 创建用户
1.创建临时表空间
create temporary tablespace zl_temp
tempfile 'D:\app\Administrator\oradata\test\zl_temp.dbf' size 100m;
2.创建表空间
create tablespace zl_01
datafile 'D:\app\Administrator\oradata\test\zl_01.dbf' size1000M;
3.创建用户
create user zl01 identified by 6370
account unlock
default tablespace zl_01
temporary tablespace zl_temp;
4.分配权限
grant dba to zl01;