cognos10.2sample(ORACLE学样例)教程.doc

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 file=d:\BIwor