ORA-03113 and ORA-03114
I have just installed Oracle 9.2.0.5 onto a new Windows 2K Server and transfer the data from our 8.1.7.4 Develop and Test database.
Both of the new instances are settup identical (checked the initialization paramteres between the two and the database is the only which is different, obviously).
The test DB seems to be working without a problem.
The develop DB is giving me problems:
Within our application (written in Delphi using ADO with oracle oleDB on an Oracle 9 client), one query gives me an ORA-03114 error (not connected to Oracle). Run the query in SQL-Plus and you get an ORA-03113 error (end-of-file communication).
The query is: select x from vw_view where y='a' and z=0;
Running a trace_in_session shows the query which fails is select x,rowid from vw_view where y='a' and z=0;
Running the query without the rowid in SQL Plus works, with the rowid field in the select you get the ORA-3113.
This didn't happen when I did the initial migration to test the procedure I was going to perform.
I am desperate for any help.
TIA
James Alcroft