Shopfloor Management Essentials database
This is the database required by Shift Book(smsb), Andon Live(smal), KPI Reporting(smkpi), Administration(smadmin) and ConfigBridge(smcb). We require this database to be set up inside a separate database schema. This means that the database can only contain the SM Essentials database objects and no objects from any other module.
Furthermore, one database schema per tenant is required. Multiple tenants can never access the same SM Essentials database.
Create database
The following script creates an empty SM Essentials database. This script is not necessary within Bosch as database provisioning will be done by the Central IT Department Bosch Digital.
Note: The Shopfloor Management database scripts require a default tablespace.
Please replace the following placeholders before executing this script.
-
$$SchemaUsername$$
-
$$SchemaPassword$$
-
$$DATAFILEPATH_1$$
-- create tablespaces
CREATE BIGFILE TABLESPACE $$SchemaUsername$$DATA_PDAMDA DATAFILE '$$DATAFILEPATH_1$$' SIZE 1G AUTOEXTEND ON NEXT 500M MAXSIZE 50G;
-- create users
create user $$SchemaUsername$$ identified by $$SchemaPassword$$
default tablespace $$SchemaUsername$$DATA_PDAMDA
temporary tablespace TEMP
quota unlimited on $$SchemaUsername$$DATA_PDAMDA;Supported Versions |
Oracle 19c Enterprise |
|---|---|
DBs / Schemas / Users |
Shopfloor Management Essentials Schema |
Required Privileges |
NEXEED_BASIC_ROLE, NEXEED_EXTENDED_ROLE, NEXEED_MONITORING_ROLE |
Relative Capacity |
5 GB / 1 line / year, depends heavily on customer specific use-case |