Updating a schema image

The Update/Add Table Definitions utility allows you to:

In this exercise, you update a schema image to reflect any changes you might have made to the data definitions for your Oracle database.

  • 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.

To update a schema image:

  1. Choose DataServer > ORACLE Utilities > Update/Add Table Definitions. The utility will ask you to verify that you are connected with a User ID and Password combination that has sufficient privileges. If the current User ID is correct, click OK, otherwise enter a different User ID and Password combination.
  2. Once you are properly connected to Oracle, the following dialog box appears:
  3. Preselect the Oracle objects that the utility uses to update the schema image. By default, the wild card symbol (*) appears in the fill-in fields. The wild cards specify that the utility will use all objects in the Oracle database, including system catalog information. You can change the criteria by typing new information in the fill-in fields.
    Note:

    Progress Software Corporation recommends that you do not specify an entry that consists exclusively of wild cards for each of the three entry fields in the dialog box. An entry that consists exclusively of wild cards might degrade the performance of the database when you perform a schema pull. (It will include system catalog files from the data source not typically included in user databases.)

    If there are links to Distributed Databases in your Oracle instance, a list of them will be displayed. Either highlight the proper link, or simply click OK.

  4. Choose OK. The Select ORACLE Objects box lists the objects and table information that you preselected:
  5. Select the objects you want to update, then choose OK. Typically, you should not include system-owned objects.
  6. To select tables by matching a pattern, choose the Select Some button. The following dialog box appears:


  7. Type the pattern that you want to match, then choose OK. The application returns to the main window.
    When you update a definition, the old definition is overwritten with the new one based on the current Oracle object. It also preserves the OpenEdge-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 OpenEdge-specific information for the previously existing columns (fields) in the definition.