日期:2014-05-16  浏览次数:20439 次

安装后创建新的用户和工作空间
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;