Understanding the Alter Repository

The alter repository consists of a set of tables designed to store the results of the PTANALYZER program run, as well as some static information to be used for reference. Once the PTANALYZER program runs, the alter repository will contain information for each definition where metadata attributes differ between the source and target databases. Use a SQL editor or reporting application to query the repository and extract the information you require. This will require a working knowledge of the Alter Repository table structure.

The alter repository consists of these tables:

• PS_PTUALTRECDATA

• PS_PTUALTRECFLDDAT

• PS_PTUALTRECFLDDEF

The structure of the tables is described in the following sections.