Adjust M3 BE temporary tables

The temporary tables in M3 Business Engine are indexed, organized tables. The primary index of the table will be placed in the default tablespace for the schema and the overflow part (table) will be placed in tablespace TMVXTEMP.

Set TMVXTEMP as default tablespace of all M3 schemas.

As an example for the schemas MVXJDTA (Standard) and CUSJDTA (Customer modification), run the following commands:

alter user MVXJDTA default tablespace TMVXTEMP;
alter user CUSJDTA default tablespace TMVXTEMP;

The commands must be run for all schemas and markets.

This adjustment will affect all tables and indexes created without the tablespace option.