Progress
DataServer
for ORACLE Guide
Verifying a Schema Image
You might want to verify that the schema image matches the data definitions in the ORACLE database. For example, if you delete the Customer table from the ORACLE database, but not from the schema image, the Verify utility reports that there is an orphaned object. You can verify the schema information from a single or from multiple tables, and then choose to update the table or tables so that the schema information matches the ORACLE definitions.
The verify utility reads the definitions in the ORACLE database and compares them to the information in the schema image. It reports the differences it finds and the degree of their severity. These are the categories of differences and how they impact your database applications:
- Minor — These differences have no impact on the usability of your application.
- Retained — The Update utility cannot correct these differences, hence the term “retained.” You must determine how severely they impact your application and change the data definitions either in the schema holder using the Data Dictionary or in the ORACLE database.
- Severe - These differences might cause your application to malfunction. When the Verify utility detects severe differences, it automatically updates the schema image to solve the discrepancies. It adjusts the information in the schema image to match the ORACLE definitions. Severe differences in definitions that the DataServer uses internally also cause the schema image to be updated.
Table 5–3 lists the differences that the utility detects.
Table 5–3: Verify Utility Report Database Object Difference Category Table Description Retained Table Foreign type Severe Table Name in Progress Retained Table Package name Severe Table ROWID index Retained Index Active Minor Index Description Retained Index Name in Progress Retained Index Unique Retained1 Index field Abbreviated Minor Index field Ascending Severe Index field Order Severe Field Case-sensitivity Retained Field Decimals Retained2 Field Description Retained Field Extent Severe Field Initial value Retained2 Field Mandatory Retained Field Name in Progress Retained Field Order Retained Field Progress data type Retained2 Field Progress format Retained2 Field Shadow-column Name Severe
- When you update an index, the index is flagged as unique if it was defined as unique in either the ORACLE database or the schema image.
- If the corresponding information in the ORACLE database is incompatible with the information in the schema holder, the affected fields are not updated. For example, if the ORACLE data type is NUMBER and the Progress data type is CHARACTER, the data type information is not updated.
Follow these steps to verify a table.
- Choose DataServer
ORACLE Utilities
Verify Table Definition. The following window appears:
![]()
- Preselect the ORACLE objects that the utility uses to update the schema image. By default, the wildcard symbol (*) appears in the fill-in fields. It specifies that the utility uses all objects in the ORACLE database, including system catalog information. You can change the criteria by typing new information in the fill-in fields.
- Choose OK. A dialog box lists the objects and table information that you preselected:
![]()
- Select the objects you want to update, then choose OK.
- To select tables by matching a pattern, choose the Select Some button. The following dialog box appears:
![]()
- Type the pattern that you want to match, then choose OK to start the verification. The following dialog box appears listing the objects and the results of the verification:
![]()
- Choose the View Reports button to view a description of the differences found. SH indicates the value in the schema image; NS indicates the value in the ORACLE database:
![]()
- Chose Close to return to the Schema Verify dialog box.
- The utility automatically selects objects with severe differences for updating. You can select or deselect all other objects as you wish.
You must resolve retained differences manually. Retained differences appear in reports until you resolve them.
- Choose OK to start the update or Cancel to quit the utility without updating the schema image.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |