Kbase 30212: Error 1461 occurs when ORACLE_HOME is not set
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2001 |
|
Solution ID: P212
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORACLE error see "ORACLE Error Messages and Codes Manual". (1252)
Schema holder does not match database schema -- file field . (1461)
CAUSE:
The error 1461 is usually reported when there are discrepancies in the schema holder definitions. The DataServer runs a schema check on every table at the first time the table is referenced in the session by a program.
However, there are times when no schema descrepencies are present. Thus the error occurs when ORACLE_HOME environment variable is not set
FIX:
When setting ORACLE_HOME, make sure that ORACLE_HOME and ORACLE_HOME/bin are included within the system PATH environment variable.