Tenant data removal

Removing the data from Material Management tables without proper archiving will cause serious data loss about traceability information. Always archive the necessary data before triggering a deletion!

Since Material Management currently does not support multitenancy, removing tenant data means to clear the database completely. This can be achieved by one of the following ways:

Removal of the database pod in the Kubernetes cluster and its attached presetting volume claim. Removing the pod without deleting the presetting volume claim leaves the data as orphan on the cluster.
Clearing all Material Management tables manually.

For the second option, the following Oracle command can be used (replace <user> with your database user, SYS privileges are required):

DROP USER <user> CASCADE;

See Oracle documentation here.