Kbase 19137: Could Not Find Oracle_users In Database (1494)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Progress 9.0x
SYMPTOM(s):
<program> --Could not find file <name> in database <db>. (1494)
prodict/ora/_ora_lkl.p Could not find table: oracle_users in database
(1494)
The following error is encountered when running Update/Add Table Definitions from the ORACLE Utilities menu under the Data Administration
CAUSE:
All the oracle_* tables (hidden tables seen from Progress Data Dictionary when connected to the ORACLE database) have not been created. The system table SEND-SQL-STATEMENT is also missing.
FIX:
The workaround to the problem is:
1) Connect to the schema holder and ORACLE.
2) From Data Administration, go to Admin menu. Then choose Load, Table contents.
3) Choose any table but when Progress asks for the file location, just hit cancel. This steps create the missing tables.