Oracle Data Warehouse Creation Tutorial ____oracle

Oracle Data Warehouse creation tutorial. How to create a data warehouse, create an example, think of graduation design requirements, recently began Oracle's Warehouse modeling practice, detailed records of the graphical interface Oracle database 12C Data Warehouse creation process.

This tutorial can be successfully created in both the Linux environment and the Windows environment. Note: either under Linux or under Windows, if you have installed Oracle database 12C correctly. A total of 14 steps, each step at least one graphic introduction, and strive to detail. Just a step-by-step installation is OK. 0.0 Open the database Configuration Assistant (DBCA Configuration Assistant), initialization is part of the installation, or you can open to create a new database instance at any time.

1.0 Choose to create a database

2.0 Create Mode Select Advanced Mode

3.1 Select Data Warehouse

3.2 Viewing Parameters

4.0 Database Identification

5.0 Management Options

6.0 Database ID

7.0 Network Configuration – Default configuration

8.0 Storage Locations

9.0 Database Options

10.1 Initialization parameters – memory

10.2 Initialization Parameters-sizing

10.3 Initialization Parameters-character Set

10.4 Initialization Parameters-Connection mode

11.0 Creating Options

12.0 Prerequisite Detection 13.0 Overview, check configuration Parameters

14.0 Start Creating

15.0 Complete, successfully created

This completes the database instance creation, has completed the Data Warehouse creation, then starts the SQL, the modelling journey.