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:

Follow these steps to update a schema image:

  1. Choose DataServer ORACLE Utilities Update/Add Table Definitions. The following dialog box appears:
  2. 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.
  3. Choose OK. A dialog box lists the objects and table information that you preselected:
  4. Select the objects you want to update, then choose OK. Typically, you should not include system-owned objects.
  5. To select tables by matching a pattern, choose the Select Some button. The following dialog box appears:
  6. 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