Progress
DataServer
for ORACLE Guide


Maintaining a Schema Holder

The Progress 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-Progress 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.

Table 3–8 lists common database operations and the required techniques.

Table 3–8: Database Operations and the Schema Holder
Database Operation
Technique
Modified a column in an ORACLE table
Update the schema image by using the DataServer for ORACLE utilities.
Added a column to an ORACLE table
Update the schema image by using the DataServer for ORACLE utilities.
Inserted 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, Progress might fail when it tries to access that table.
Added an index to an ORACLE table
If the index you add is for a field that is case insensitive, be sure to add the appropriate value in the shadow column named U##column. For example, if the indexed column contains the value uk, assign the value UK to the shadow column to ensure a case-insensitive index.
Modified data definitions in the schema image
Update the ORACLE database to reflect your changes by using the Incremental Schema Migration utility.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095