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.