| # To reconfigure tables This topic describes the procedure to reconfigure tables. Important! The sections below describe the sessions that you must use to complete the procedure. However, they do not describe all details of these sessions. For detailed session information, refer to the Infor Web Help. Procedure aim 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 will want to control when and who performs the reconfiguration activity. You can separate the convert process and the reconfigure process. Procedure result and prerequisites Result The structure of the tables in the database matches the new table and domain definitions. Prerequisites A table reconfiguration requires exclusive access to the table, because the system will drop the table. Procedure summary To execute the convert and reconfigure process as 2 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) Note You must log off and log on again to use the new tables. Procedure details Step 1. Convert the data dictionary information to runtime Run the Convert to Runtime Data Dictionary (ttadv5215m000) session with the following 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 the following selection settings:
Check Box | Selected
Domains | No
Tables | No
Reconfigure Tables | Yes
Related topics Domains Table definitions Data dictionaries To create a data model |