Oracle Audio Technologies 13 manual

Oracle® Retail Data Warehouse

Database Installation Guide

Release 13.0

April 2008

Contents

Main Page Value-Added Reseller (VAR) Language Page Contents Page Preface Audience Related Documents Customer Support Review Patch Documentation Conventions Preinstallation Tasks RDW Architecture on Oracle Implementation Capacity Planning Check Database Server Hardware Requirements Check Database Server Software Requirements Other Software Requirements for the Data Warehouse Check Client System Requirements Create UNIX User Accounts Create UNIX Directories Alter Directory Ownership and Privileges Copy Profiles for RDW User Installation Tasks Establish Data Warehouse Partitioning Strategy Create the RDW Database and Tablespaces Create the Database as Follows Create RDW Tablespaces Load RDW Database Create RDW Schema Owners Create RDW Datamart-level tables Set up RDW User Permissions Ignore any text that is generated from invalids.sql if no objects need to be validated. Configure RETL Data Population Populate Datamart Default Data This script executes the following SQL scripts: Populate Time Dimension Create Standalone Time Create Time in RDW Populate Static Dimension Data Install Oracle Configuration Manager Page A Appendix: Development Database Schema Implementation RDW 13.0 Development Environment Page B Appendix: RDW Code Tree Page C Appendix: Oracle 10g Database Creation Scripts Appendix: Oracle 10g Database Creation Scripts Install Oracle Configuration Manager Appendix: Oracle 10g Database Creation Scripts D Appendix: Tablespace Creation Scripts Page E Appendix: Installation Order