BI,Cognos10
Cognos sample 配置
G:\BIworksoft\cognos10.2\c10_64\webcontent\samples\datasources
该路径的datasource\oracle下包含了Sample数据的DMP数据文件,在后面的配置中会将DMP数据备份文件导入到Oracle中。
G:\BIworksoft\cognos10.2\c10_64\webcontent\samples\datasources\oracle
该路径下有两个压缩包CSTATD和GS_DB_ORA,解压得到需要导入Oracle的dmp文件
以管理员身份登录数据库,执行下列数据库脚本:
create tablespace CSTATD datafile 'D:\Oracle\product\11.2.0\oradata\orcl\CSTATD.dbf' size 50M autoextend on;
create tablespace GOSALES datafile 'D:\Oracle\product\11.2.0\oradata\orcl\GOSALES.dbf' size 100M autoextend on;
create tablespace GOSALESRT datafile 'D:\Oracle\product\11.2.0\oradata\orcl\GOSALESRT.dbf' size 5M autoextend on;
create tablespace GOSALESDW datafile 'D:\Oracle\product\11.2.0\oradata\orcl\GOSALESDW.dbf' size 200M autoextend on;
create tablespace GOSALESMR datafile 'D:\Oracle\product\11.2.0\oradata\orcl\GOSALESMR.dbf' size 25M autoextend on;
create tablespace GOSALESHR datafile 'D:\Oracle\product\11.2.0\oradata\orcl\GOSALESHR.dbf' size 25M autoextend on;
创建用户并授权:
create user CSTATD identified by CSTATD default tablespace CSTATD;
grant connect,resource,dba to CSTATD;
create user GOSALES identified by GOSALES default tablespace GOSALES;