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;

 

 

转载于:https://www.cnblogs.com/meimao5211/p/3613142.html