SQLException: OALL8 is in an inconsistent state
507183Sep 8 2006 — edited Sep 9 2006I am getting the above error every time I attempt to execute the below query. Using Oracle XE 10.2.0.1-1.0, the latest JDBC driver.
I have also attempted to execute the query against Oracle 8i and Oracle 10g Standard Edition, in both of these cases the query executed perfectly (no errors, expected results). This leads me to suspect that this is possibly a configuration problem.
select * from table1 c, table2 s, table3 f, table4 cs, table5 n where c.cid=cs.cid (+) and c.cid=f.cid (+) and c.subsystem=s.subsystem and c.cid=n.cid (+) and c.subsystem in ('text here', 'other text') and c.open=0 and n.note='Changed Status from Open to Closed.' and TRUNC(n.datetime) >= TO_DATE('2006-1-1', 'YYYY-MM-DD') and TRUNC(n.datetime) <= TO_DATE('2006-9-11', 'YYYY-MM-DD') order by s.system asc, c.subsystem asc
If I need to post anymore info. let me know.