Oracle Audio Technologies 13 Manuale Utente

 

 

Audience ............................................................................................................................... vii

 

Related Documents.............................................................................................................. vii

 

Customer Support................................................................................................................ vii

 

Review Patch Documentation ............................................................................................ vii

 

Oracle Retail Documentation on the Oracle Technology Network............................... vii

 

Conventions.........................................................................................................................viii

 

 

Implementation Capacity Planning......................................................................................2

 

Check Database Server Hardware Requirements ..............................................................2

 

Check Database Server Software Requirements.................................................................3

 

Other Software Requirements for the Data Warehouse ....................................................4

 

Check Client System Requirements .....................................................................................4

 

Create UNIX User Accounts..................................................................................................4

 

Create UNIX Directories ........................................................................................................4

 

Alter Directory Ownership and Privileges..........................................................................5

 

Copy Profiles for RDW User .................................................................................................6

 

 

Establish Data Warehouse Partitioning Strategy................................................................7

 

Create the RDW Database and Tablespaces........................................................................8

 

Create the Database as Follows......................................................................................8

 

Create RDW Tablespaces................................................................................................8

 

Load RDW Database ..............................................................................................................9

 

Create RDW Schema Owners.........................................................................................9

 

Create RDW Datamart-level tables ...............................................................................9

 

Set up RDW User Permissions .......................................................................................9

 

Configure RETL ....................................................................................................................10

 

Data Population ....................................................................................................................10

 

Populate Datamart Default Data .................................................................................11

 

Populate Time Dimension ............................................................................................12

 

Populate Static Dimension Data ..................................................................................14

 

Install Oracle Configuration Manager ...............................................................................15