Kbase P147487: Error 1461 When Querying Oracle Tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 1461 When Querying Oracle Tables
Schema holder does not match database schema -- file field . (1461)
Error only occurs against one table
Oracle error 942 is seen in dataserv.lg when verbose logging is enabled
Ora 942, table or view does not exist
Oracle error 942 appears at the same time error 1461 is seen
FACT(s) (Environment):
There are three tables that are just pulled by the same Oracle user
Only one out of three tables has the issue
The problem table is owned by a different Oracle user than the other two tables
Schema pull done by the same Oracle user
Schema pull was successful with no errors
Oracle
Oracle DataServer
CAUSE:
The Oracle user (not the table owner) is not given select permissions on the table owned by a different owner
FIX:
Login as Oracle dba and grant select privilege to the user for the table
grant select on table_name to user_name