Kbase P108701: Error (1439) running a query in EXCLUSIVE-LOCK against an ORACLE table when the .df file has been im
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/12/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
Oracle DataServer
SYMPTOM(s):
Error 1439 when running a query in EXCLUSIVE-LOCK against an ORACLE table
View of more than one table is not supported (1439).
The error does not occur in NO-LOCK
The table has been loaded from a Progress 8 schema holder
The DB-LINK-NAME property is informed for the table in the .df file
CAUSE:
The exact cause is unknown at the time of this writing.
FIX:
To fix this problem, remove the DB-LINK-NAME information in the .df file and re-load the table into the schema holder.
Follow the steps below:
1. Delete the DB-LINK-NAME related to the table in the .df file dumped from Progress 8.
2. Delete the table in the schema holder from the Data Dictionary
3. Load the .df file modified in step #1 into the schema holder from Data Administration.