Kbase P130127: Can not Add / Update table definitions through Oracle database link
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2008 |
|
Status: Unverified
FACT(s) (Environment):
IBM AIX
Progress 9.1D
Oracle DataServer
SYMPTOM(s):
Can not Add / Update table definitions through Oracle database link
After database link is displayed. selecting it brings back the dictionary main screen
The new tables are already deleted from the schema holder
No problem doing schema pull of the same tables through the same oracle database link
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Do a schema pull of the tables, dump the df out and load it into the schema holder.
Exact steps:
1. prodb testsh empty(build an empty database to be used as test schema holder)
2. pro testsh -rx (connect to the test schema holder with permission to update schema)
3. Go to Dictionary -> DataServers -> Oracle utilities -> Create schema
4. Enter credentials for connection, and click OK
5. At the next display of database links, select the desired database link
6. At the display of available tables, select the desired table
7. Click OK to pull the tables into the test schema holder
8. Go to Data Admin -> Dump data and definitions -> Dump the definitions for the tables
9. Open the dumped df, and remove the header part which has database schema and code page information, so the df only contains create table statements
10. Connect to the real schema holder, select the desired Oracle schema image
11. Go to Data Admin, Load data and definitions, select load definitions, pick up the df dumped from step 8, and load it into the schema holder