ORACLE 创建表空间及用户
/*创建存放原始数据的表空间*/
create tablespace Djzh_original datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\Djzh_original01.dbf' size 2048M autoextend on;
/*创建业务表空间*/
create tablespace Djzh_business datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\Djzh_business01.dbf' size 2048M autoextend on;
/*创建的原始数据的用户名和密码*/
CREATE USER Djzh_original identified by Djzh_original default tablespace Djzh_original ;
grant dba to Djzh_original;
/*创建的业务数据的用户名和密码*/
CREATE USER Djzh_business identified by Djzh_business default tablespace Djzh_business ;
/*创建最高权限*/
grant dba to Djzh_business;