Kbase P17880: Can not update schema, error (328) (6483), after upgrade of Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle
Oracle DataServer
SYMPTOM(s):
Can not perform add/update table definitions
Please also verify you have SELECT privileges on the needed system tables
and the proper version of ORACLE (7 or 8) was selected when the schema
holder was created (328) (6483)
Prefer not to rebuild new schema holder
CHANGE:
Upgraded Oracle from V7 to V8
CAUSE:
During schema update, dataserver checks Oracle system tables for permissions to perform the operation, between Oracle 7 and Oracle 8, the system tables dataserver checks are different, thus the error.
FIX:
If prefer not to rebuild schema holder, following can be used to work around the error:
1. From the data administration, select the Oracle database as the working database and dump the definition.
2. Open the df and remove create database statement
3. Create a new schema holder, in the new schema holder, create an oracle image, with the version selected as Oracle version "8", selecting no Oracle table.
4. Select the new oracle schema image, load the .df produced earlier.