To reconfigure tables

When you change the table definitions, or the corresponding domains, for tables that already exist in the database, you must reconfigure the tables according to the new table and domain definitions.

A table configuration process will perform these actions:

Unload data that is in the existing table, for all companies in the package combination
Drop the existing table, for all companies in the package combination
Create the table according to the new table and domain definitions
Re-load the data into the table

This is a process that you want to control when and who performs the reconfiguration activity. You can separate the convert process and the reconfigure process.

The sessions that you must use to complete the procedure do not describe all details. For detailed session information, see the Infor Web Help.

After the procedure is completed, the structure of the tables in the database matches the new table and domain definitions.

Execute the convert and reconfigure process as two separate steps:

Convert the data dictionary information to runtime - Convert to Runtime Data Dictionary (ttadv5215m000)
Reconfigure the tables in conjunction with the DBA or system administrator - Convert to Runtime Data Dictionary (ttadv5215m000)
You must log off and log on again to use the new tables.

Prerequisites

A table reconfiguration requires exclusive access to the table, because the system will drop the table.

Step 1. Convert the data dictionary information to runtime

Run the Convert to Runtime Data Dictionary (ttadv5215m000) session with these selection settings:

Check Box	Selected
Domains	Yes
Tables	Yes
Reconfigure Tables	No

Step 2. Reconfigure the tables

To reconfigure the tables in conjunction with the DBA or system administrator, run the Convert to Runtime Data Dictionary (ttadv5215m000) session with these selection settings:

Check Box	Selected
Domains	No
Tables	No
Reconfigure Tables	Yes