EPM常用新建系统用户语句

--创建一个临时表空间--
create temporary tablespace EPM_SYS_TEMP
tempfile 'D:\app\bitest\oradata\hypdb\EPM_SYS_TEMP.dbf'
size 100m
autoextend on
next 250m maxsize unlimited
extent management local;

--hyperion 应用需要使用的临时表空间--
create temporary tablespace EPM_USR_TEMP
tempfile 'D:\app\bitest\oradata\hypdb\EPM_USR_TEMP.dbf'
size 100m
autoextend on
next 250m maxsize unlimited
extent management local;

create temporary tablespace EPM_USR_TEMPTEST
tempfile 'D:\app\bitest\oradata\hypdb\EPM_USR_TEMPTEST.dbf'
size 100m
autoextend on
next 250m maxsize unlimited
extent management local;

 

----创建需要的表空间--

--hyperion 主数据存储--
create tablespace TS_EPM_SYS_PLN
logging
DATAFILE 'D:\app\bitest\oradata\hypdb\TS_EPM_SYS_PLN.dbf'
size 100m
autoextend on
next 10m
maxsize unlimited
extent management local;

--hyperion 应用的关系库--
create tablespace EPM_USR_PLN_APP
logging
datafile 'D:\app\bitest\oradata\hypdb\EPM_USR_PLN_APP.dbf'
size 100m
autoextend on
next 250m
maxsize unlimited
extent management local;

--FOUNDATION 主数据存储--
create tablespace TS_EPM_SYS_FOUNDATION
logging
datafile 'D:\app\bitest\oradata\hypdb\TS_EPM_SYS_FOUNDATION.dbf'
size 100m
autoextend on
next 250m
maxsize unlimited
extent management local;

--EAS 主数据存储--
create tablespace TS_EPM_SYS_EAS
logging
datafile 'D:\app\bitest\oradata\hypdb\TS_EPM_SYS_EAS.dbf'
size 100m
autoextend on
next 100m
maxsize unlimited
extent management local;

---- CM -----
create tablespace TS_EPM_SYS_CM
logging
datafile 'D:\app\bitest\oradata\hypdb\TS_EPM_SYS_CM.dbf'
size 100m
autoextend on
next 250m
maxsize unlimited
extent management local;

--RA-----

create tablespace TS_EPM_SYS_ra
logging
datafile 'D:\app\bitest\oradata\hypdb\TS_EPM_SYS_RA.dbf'
size 100m
autoextend on
next 250m
maxsize unlimited
extent management local;

//创建用户并指定表空间
--hyperion--

epm_sys_pln

create user epm_sys_pln identified by epm_sys_pln
default tablespace TS_EPM_SYS_PLN
temporary tablespace EPM_SYS_TEMP;
grant dba to epm_sys_pln;

--hyperion APP--
epm_usr_pln

create user epm_usr_pln identified by epm_usr_pln
default tablespace EPM_USR_PLN_APP
temporary tablespace EPM_USR_TEMP;
grant dba to epm_usr_pln;

epm_usr_pln_test

create user epm_usr_pln_test identified by epm_usr_pln_test
default tablespace EPM_USR_PLN_APP
temporary tablespace EPM_USR_TEMP;
grant dba to epm_usr_pln_test;

--FOUNDATION--
EPM_SYS_FOUNDATION

create user EPM_SYS_FOUNDATION identified by epm_sys_foundation
default tablespace TS_EPM_SYS_FOUNDATION
temporary tablespace EPM_SYS_TEMP;
grant dba to EPM_SYS_FOUNDATION;

--EAS--
epm_sys_eas

create user epm_sys_eas identified by epm_sys_eas
default tablespace TS_EPM_SYS_EAS
temporary tablespace EPM_SYS_TEMP;
grant dba to epm_sys_eas;

 
---- CM -----
epm_sys_cm

create user epm_sys_cm identified by epm_sys_cm
default tablespace TS_EPM_SYS_CM
temporary tablespace EPM_SYS_TEMP;
grant dba to epm_sys_cm;

---- RA -----
epm_sys_ra

create user epm_sys_ra identified by epm_sys_ra
default tablespace TS_EPM_SYS_ra
temporary tablespace EPM_SYS_TEMP;
grant dba to epm_sys_ra ;