Try OpenEdge Now
skip to main content
DataServer for Oracle
The DataServer Tutorial : OpenEdge DB-to-Oracle Incremental Schema Migration utility : Updating the Oracle database

Updating the Oracle database

You should review, and modify if necessary, the delta.sql file that the utility generates before applying it. You can apply the delta.sql file to the Oracle database through SQL-based tools, such as Oracle's SQL*Plus.
After applying the delta.sql to the Oracle database, you must update the original schema holder by loading the new delta.df file into the original schema holder so that the original schema holder reflects the modifications you made to the Oracle database.
Note: If you select the Char semantics toggle box, you should run the Update/Add Table Definitions utility so that the correct byte length is stored in the schema holder.