Kbase 21001: Oracle DataServer: Error 1461 Querying a Table when Oracle table /index/field name is quoted
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Schema holder does not match database schema -- file X field Y. (1461)
The error is encountered when run a program that accesses the ORACLE database through the DataServer for ORACLE
The definitions in schema holder match the definitions in Oracle database
The schema is just pulled from Oracle
Oracle table has been created via script which included the object name in double quotes. For example:
CREATE TABLE "name" ("column1" NUMBER(2),....)
The table name is double quoted in lower cases
CAUSE:
By default, ORACLE is not case-sensitive on object names, storing them in uppercase in the data dictionary. The use of double quotes in the table / column name will create a case sensitive object name. Therefore, these tables / indexes / columns must also be referenced with double quotes. Any attempt to reference that object without the double quotes and the same case, will fail.
FIX:
Drop the table and recreate it without the quotes around the table / index / column name. For example: CREATE TABLE name (column1 NUMBER(2),....)
CAUTION: Be sure to dump the data of the ORACLE table before dropping it.
Or create views for the tables without using double quotes.