Kbase P43524: Error 1461 occurs against a new Oracle instance when user privs are not correctly set
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/11/2004 |
|
Status: Verified
FACT(s) (Environment):
Oracle
Oracle DataServer
SYMPTOM(s):
Getting error 1461 when connecting to an Oracle database
Schema holder does not match database schema --file <DB_Name>.<Owner_Name>.<Table_Name> field <Field_Name>. (1461)
Progress client is connecting to an existing schema holder
Progress client is connecting to a newly created Oracle database instance
A new schema holder was not created for the new Oracle database instance
CHANGE:
A new Oracle database instance was created by exporting table definitions from one Oracle instance to another a new empty instance
CAUSE:
The select privileges against the system tables are not granted to the dataserver user within the newly created Oracle database instance
FIX:
Grant select privileges to dataserver user on following system objects
sys.ts$
sys.col$
sys.com$
sys.con$
sys.dual$
sys.icol$
sys.ind$
sys.obj$
sys.seq$
sys.tab$
sys.user$