ora-03113

ORA-07445 access violation

I have this error when running a large query on oracle. any advice? I'm using pl sql version 10.2 I have noticed that the error is due to creating a view that is based up on many tables, and when I do a select from this view to a specific parameter with a where condition I got that error. When I checked the logs I found out this o...

ORA-03113 while executing a sql query

I have a 400 line sql query which is throwing exception withing 30 seconds ORA-03113: end-of-file on communication channel Below are things to note: I have set the timeout as 10 mins There is one last condition when removed resolves this error. This error came only recently when I analyzed indexes. The troubling condition is ...