cognos10.2sample(ORACLE学样例)课案
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;
grant connect,resource,dba to GOSALES;
create user GOSALESRT identified by GOSALESRT default tablespace GOSALESRT;
grant connect,resource,dba to GOSALESRT;
create user GOSALESDW identified by GOSALESDW default tablespace GOSALESDW;
grant connect,resource,dba to GOSALESDW;
create user GOSALESMR identified by GOSALESMR default tablespace GOSALESMR;
grant connect,resource,dba to GOSALESMR;
create user GOSALESHR identified by GOSALESHR default tablespace GOSALESHR;
grant connect,resource,dba to GOSALESHR;
打开CMD，执行数据库的导入：
imp CSTATD/CSTATD@orcl file=d:\BIworksoft\dmp\CSTATD.dmp full=y
imp GOSALESRT/GOSALESRT@orcl file=d:\BIworksoft\dmp\GOSALESRT.dmp full=y
imp GOSALESDW/GOSALESDW@orcl file=d:\BIworksoft\dmp\GOSALESDW.dmp full=y
imp GOSALESMR/GOSALESMR@orcl file=d:\BIworksoft\dmp\GOSALESMR.dmp full=y
imp GOSALESHR/GOSALESHR@orcl f
转播
