安装后创建新的用户和工作空间
安装后创建新的用户和工作空间
Sql代码
create tablespace znzj
logging
datafile 'D:\app\myyuren\oradata\orcl\znzj.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create temporary tablespace znzj_temp
tempfile 'D:\app\myyuren\oradata\orcl\znzj_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
create user znzj identified by znzj
default tablespace znzj
temporary tablespace znzj_temp ; grant connect,resource,imp_full_database,exp_full_database to znzj;