Hi,
I developed my application with oracle client 11 and oracle server 11 in code first. Now I deployed my application on the test server and I got "ORA-00952 - Table or view does not exist" at first query.
So I tried from my machine with developing environment and I get the same when I use Oracle 10 meanwhile there aren't problems when I use Oracle 11 (using the same compiled code I change only the TNS Name)
How can I resolve it?
Thank you
Claudio
ORA-00952 - Table or view does not exist
It seems like an old schema name is used in the queries, which are generated by EF engine in the new environment. You can check this using the dbMonitor tool that performs per-component tracing of database events such as commit, rollback, SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
You can turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/ ... orkarounds.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
You can turn off the generation of the schema name in run-time queries using the IgnoreSchemaName option of EF-provider configuration: http://www.devart.com/blogs/dotconnect/ ... orkarounds.
-
- Posts: 2
- Joined: Fri 30 Sep 2011 07:52
Resolved
Thank you for you response, thanks to dbMonitor I found my problem.
The problem was that the generated query have the " on every filedname and table name and so the query is case sensitive.
Thank you
Claudio
The problem was that the generated query have the " on every filedname and table name and so the query is case sensitive.
Thank you
Claudio
Please try the config.Workarounds.DisableQuoting = true; workaround.