cognos配置oracle数据源连接,安装部署Cognos Sample并配置Oracle数据源

数据包在 D:/Program

Files/cognos/c8/webcontent/samples/datasources/oracle

create tablespace tbs_cogsamp datafile

'D:/oracle/product/10.2.0/oradata/orcl/cognos.dbf' size 500M

autoextend off;

create user gosales identified by cognos default tablespace

tbs_cogsamp;

create user gosaleshr identified by cognos default tablespace

tbs_cogsamp;

create user gosalesmr identified by cognos default tablespace

tbs_cogsamp;

create user gosalesrt identified by cognos default tablespace

tbs_cogsamp;

create user gosalesdw identified by cognos default tablespace

tbs_cogsamp;

--------------------

alter user gosales quota unlimited on tbs_cogsamp;

alter user gosaleshr quota unlimited on tbs_cogsamp;

alter user gosalesmr quota unlimited on tbs_cogsamp;

alter user gosalesrt quota unlimited on tbs_cogsamp;

alter user gosalesdw quota unlimited on tbs_cogsamp;

grant connect, resource to gosales, gosaleshr, gosalesmr,

gosalesrt, gosalesdw;

grant create any view to gosalesdw;

---------------------------

cmd下

imp gosales/cognos@orcl

file=d:\qq\GOSALES.dmp log=imp_GOSALES.log full=y rows=y indexes=y

constraints=n

imp gosaleshr/cognos@orcl

file=d:\qq\GOSALESHR.dmp log=imp_GOSALESHR.log full=y rows=y

indexes=y constraints=n

imp gosalesmr/cognos@orcl

file=d:\qq\GOSALESMR.dmp log=imp_GOSALESMR.log full=y rows=y

indexes=y constraints=n

imp gosalesrt/cognos@orcl

file=d:\qq\GOSALESRT.dmp log=imp_GOSALESRT.log full=y rows=y

indexes=y constraints=n

imp gosalesdw/cognos@orcl

file=d:\qq\GOSALESDW.dmp log=imp_GOSALESDW.log full=y

6、调整各用户之间的约束关系

SQL> @d:\qq\gs_or_modify.sql;