Progress
DataServer
for ORACLE Guide
Updating a Schema Image
In this exercise, you update a schema image to reflect any changes you might have made to the data definitions for your ORACLE database.
The Update/Add Table Definitions utility allows you to:
- Add additional object definitions from the ORACLE database to a schema image. Use this option if you add a new table or view to the ORACLE data definition and want that change reflected in the schema image.
- Update existing object definitions in a schema image to reflect a change in the supporting ORACLE database object definitions.
Follow these steps to update a schema image:
- Choose DataServer
ORACLE Utilities
Update/Add Table Definitions. The following dialog box 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. Typically, you should not include system-owned objects.
- 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. Progress returns to the main window.
When you update a definition, Progress overwrites the old definition with the new one based on the current ORACLE object. It also preserves the Progress-specific table information. So, if you want to add a new column to a table in your ORACLE database and then update the definition, you do not have to re-enter all of the Progress-specific information for the previously existing columns (fields) in the definition.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |