Increasing tablespace for the Labor Budgeting Module
Labor Budgeting processes large volumes of data from the forecast tables and their respective forecast location summaries. Consequently, tablespaces must be increased in size as the table sizes increases.
Important tips:
- Allocate about 25 percent of the index tablespace for data.
- The 4K tablespace should be allocated with the space from the calculations.
- The 8K tablespace should initially be allocated with about 25% of the space required for the 4K tablespace.
- Growth of all tablespaces varies, depending on usage patterns.
- Space should be regularly monitored, and tablespaces should be expanded as required.
By modifying the installation scripts, space allocations can be increased before the database is created, or altered after that database has been created. Use these database commands to make modifications:
| Database | New Installation |
|---|---|
| Oracle | release root\WB5.0\DefaultDatabase\Schema\Oracle\DB Create Scripts UNIX\9i\004-create_wb_tbsp.sql UNIX\10g\004-create_wb_tbsp.sql Windows\9i\tablespace\create_wb_tbsp.sql Windows\10g\tablespace\create_wb_tbsp.sql |
| SQL Server | No new tablespaces |
These examples are commands that you can use to increase Oracle tablespaces:
ALTER DATABASE DATAFILE '/fsdata/oradata/dbname/WB_BDG_DATA01.dbf' RESIZE 300M;
ALTER DATABASE DATAFILE '/fsindx/oradata/dbname/WB_BDG_INDX01.dbf' RESIZE 300M;For large installations, you may need to add files to the tablespaces to allow for larger volumes.