Control Tables

Control tables contain UDCs, menus, and data dictionary items. An upgrade merges your control tables from one release level to the next using the change table process, which uses your control tables, not system tables, as the basis for the data merge.

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

Object	Preserved	Replaced	Comments
Data dictionary custom changes.	X		This object includes changes to row, column, and glossary text. The upgrade process uses your data dictionary as the base, and in case of a conflict with system data items, your changes override. Create new data items using system codes 55 through 59.
UDCs.	X		The upgrade process merges any new, hard-coded values. (Oracle-owned values are stored in systems 90 and above, and H90 and above.) The process also reports any hard-coded values that conflict with your custom values.
Menus.	X		In case of a conflict with base menus, your custom changes override.
Columns added or removed from existing control tables.		X