Kbase P82579: What are the steps to upgrade the oracle DataServer from progress version 9.1x to OpenEdge Release 1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/12/2008 |
|
Status: Verified
GOAL:
What are the steps to upgrade the oracle DataServer from progress version 9.1x to OpenEdge Release 10.0x?
FACT(s) (Environment):
Oracle DataServer
Progress 9.1x
OpenEdge 10.x
FIX:
There are two options:
1. Do nothing and go on with the upgrade.
If you have shadow columns (U## columns) for the fields that are associated with the indexes, it will work with OpenEdge Release 10.0x. However, OpenEdge Release 10.0x does not require shadow columns since it takes advantage of the upper functions supported by OCI 8.
2.
a) Delete the indexes and the shadow columns from the oracle database using oracle tools.
b) Re-create the indexes with oracle's upper function with the same name as it was before the deletion, using the oracle tools.
c) Perform "Update/Add Table Definition..." utility of the oracle DataServer tools to pull all the tables back to the schema holder.