Symptoms
After creating and saving a new view with the Data view tool, trying toaccess the newly created view results in the following run-time error:

‘-2147217865 (80040e37)’: ORA-00942: table or view does not exist.
Resolution
The Data View is saving the view name in lower case to the Oracle database,but Oracle sees views all in upper case.