Tablespace

A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments. The reporting feature requires reporting schemas in both Emptoris® Contract Management and Emptoris Spend Analysis.

Create the following tablespace for the reporting schema in both Emptoris Contract Management and Emptoris Spend Analysis.
Table 1. Tablespace for reporting
Tablespace Use Size
Tablespace for data Data Start with 2 GB, increase as the Emptoris Contract Management and Emptoris Spend Analysis transactional database grows.
Temporary TEMP Start with 2 GB, increase as the database grows.
Rollback Rollback Start with 2 GB, increase as the database grows.