<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/EnterpriseStudio/onlinemanual/to_reconfigure_tables" xml:lang="en" TopicType="Overview">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">To reconfigure tables</Title>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>reconfigure</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>runtime data dictionary</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>data model</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>domain</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>table definition</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>table</Level2>
		</Keyword>
	</Header>
	<AimSection><Paragraph class="Default">This topic describes the procedure to reconfigure tables.</Paragraph>
	</AimSection>
	<Important><SectionTitle>
                                 Important!
                              </SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
	</Important>
	<GeneralSection><SectionTitle>Procedure aim</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
		<List><ListIntro>A table configuration process will perform these actions:</ListIntro>
			<ListItem>Unload data that is in the existing table, for all companies in the package combination</ListItem>
			<ListItem>Drop the existing table, for all companies in the package combination</ListItem>
			<ListItem>Create the table according to the new table and domain definitions</ListItem>
			<ListItem>Re-load the data into the table</ListItem>
		</List>
		<Paragraph class="Default">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.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Procedure result and prerequisites</SectionTitle>
		<Tip><SectionTitle>Result</SectionTitle>
			<Paragraph class="Default">The structure of the tables in the database matches the new table and domain definitions.</Paragraph>
		</Tip>
		<Tip><SectionTitle>Prerequisites</SectionTitle>
			<Paragraph class="Default">A table reconfiguration requires exclusive access to the table, because the system will drop the table.</Paragraph>
		</Tip>
	</GeneralSection>
	<GeneralSection><SectionTitle>Procedure summary</SectionTitle>
		<ProcedureList><ListIntro>To execute the convert and reconfigure process as 2 separate steps:</ListIntro>
			<ListItem>Convert the data dictionary information to runtime - <GUIRef href="" role="manual">Convert to Runtime Data Dictionary (ttadv5215m000)</GUIRef>
			</ListItem>
			<ListItem>Reconfigure the tables in conjunction with the DBA or system administrator - <GUIRef href="" role="manual">Convert to Runtime Data Dictionary (ttadv5215m000)</GUIRef>
			</ListItem>
		</ProcedureList>
		<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
			<Paragraph class="Default">You must log off and log on again to use the new tables.</Paragraph>
		</Note>
	</GeneralSection>
	<ProcedureSection><SectionTitle>Procedure details</SectionTitle>
		<Steps><Step><StepTitle>Convert the data dictionary information to runtime</StepTitle>
				<Paragraph class="Default">Run the <GUIRef href="" role="manual">Convert to Runtime Data Dictionary (ttadv5215m000)</GUIRef> session with the following selection settings:</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD rowspan="1" colspan="1">Check Box</TD>
							<TD rowspan="1" colspan="1">Selected</TD>
						</TR>
					</THEAD>
					<TBODY><TR><TD rowspan="1" colspan="1">Domains</TD>
							<TD rowspan="1" colspan="1">Yes</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Tables</TD>
							<TD rowspan="1" colspan="1">Yes</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Reconfigure Tables</TD>
							<TD rowspan="1" colspan="1">No</TD>
						</TR>
					</TBODY>
				</TABLE>
			</Step>
			<Step><StepTitle>Reconfigure the tables</StepTitle>
				<Paragraph class="Default">To reconfigure the tables in conjunction with the DBA or system administrator, run the <GUIRef href="" role="manual">Convert to Runtime Data Dictionary (ttadv5215m000)</GUIRef> session with the following selection settings:</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD rowspan="1" colspan="1">Check Box</TD>
							<TD rowspan="1" colspan="1">Selected</TD>
						</TR>
					</THEAD>
					<TBODY><TR><TD rowspan="1" colspan="1">Domains</TD>
							<TD rowspan="1" colspan="1">No</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Tables</TD>
							<TD rowspan="1" colspan="1">No</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Reconfigure Tables</TD>
							<TD rowspan="1" colspan="1">Yes</TD>
						</TR>
					</TBODY>
				</TABLE>
			</Step>
		</Steps>
	</ProcedureSection>
	<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/domains" role="manual">Domains</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/table_definitions" role="manual">Table definitions</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/data_dictionaries" role="manual">Data dictionaries</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_create_a_data_model" role="manual">To create a data model</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
