Maintaining a schema holder

The OpenEdge Data Administration tool provides a set of Oracle utilities that you can use to maintain a schema holder. The DataServer Tutorial describes these utilities.

If you are using non-OpenEdge applications to change the structure of the supporting Oracle database, be sure to update the schema image to reflect those changes. Some database operations require a certain technique to ensure that the schema image and the supporting database function together.

The following table lists common database operations and the required techniques.

Table 1. Database operations and the schema holder
Database operation Technique
Modify a column in an Oracle table Update the schema image by using the OpenEdge DataServer for Oracle utilities.
Add a column to an Oracle table Update the schema image by using the OpenEdge DataServer for Oracle utilities.
Insert a row in an Oracle table Use the Oracle sequence generator to generate a value. Assign that value to the PROGRESS_RECID column for that row. If you do not use the sequence generator, ABL might fail when it tries to access that table.
Add an index to an Oracle table
Note: The index cannot be a function-based index.
 Update the schema image by using the DataServer for Oracle utilities.
Modify data definitions in the schema image Update the Oracle database to reflect your changes by using the Incremental Schema Migration utility.