Create the Oracle database with the following tablespaces. See the Oracle documentation for instructions on creating the database.
The following table specifies the minimum tablespace size required:
|
Tablespace |
Size |
|---|---|
|
SYSTEM tablespace |
1024 MB + 100 MB for each HxGN EAM schema |
|
EAM data tablespace |
4096 MB for Production 2048 MB for Training |
|
EAM index tablespace |
4096 MB for Production 2048 MB for Training |
|
DATAWAREHOUSE data tablespace |
1024 MB for Production 128 MB for Training |
|
DATAWAREHOUSE index tablespace |
256 MB for Production 128 MB for Training |
|
TEMP tablespace |
At least 1024 MB |
|
Undo tablespace |
At least 1024 MB of automatically managed undo tablespace |
To maximize the performance of the data warehouse load procedure, Data Warehouse
tables and indexes are created with the NOLOGGING keyword. If you replicate your production
database using a tool such as Oracle DataGuard that relies on data written to the
recovery data structures, and you want the Data Warehouse data to be included in the
replicated database, alter the tables to enable LOGGING.