数据库的建立

创建表空间
create tablespace tp_scm
datafile 'E:\app\XIEJIACHEN\oradata\tp_scm.dbf' size 100m
autoextend on next 1m 
maxsize 3000m
extent management local
segment space management auto;

创建临时表空间
create temporary tablespace tp_scm_temp  
tempfile 'E:\app\XIEJIACHEN\oradata\tp_scm_temp.dbf' 
size 50m  
autoextend on  
next 50m maxsize 1024m  
extent management local;  

创建用户
create user scm identified by scm default tablespace tp_scm temporary tablespace tp_scm_temp;
grant connect,resource,dba to scm;