安装后创建新的用户和工作空间

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;