Table Specifications

An upgrade merges your table specifications from one release level to the next.

This table describes the table specification elements that are preserved or replaced during an upgrade:

Object	Preserved	Replaced	Comments
New Tables.	X
Custom indexes to tables.	X
Columns added to or removed from existing tables.		X	This object includes changing field length, field type, and decimal position. Instead of adding a new column to an existing table, use a tag table with system codes 55 through 59.

For custom tag files, be aware of data item changes in the data dictionary. In subsequent releases, JD Edwards EnterpriseOne software might contain changes to certain attributes of a data item, such as its size, that might affect data integrity and how the data is stored in the database. For this reason, you might need to use Oracle's JD Edwards EnterpriseOne Table Conversion tool to convert the tag file data to the new release level. For base files, the upgrade process automatically applies the data dictionary to the new release level. An upgrade preserves custom indexes for the custom tag files.