I am getting ORA:600 error when trying to select * from a particular view. If I directly query the base table on which the view is based then this error is not coming. the query is fetching rows properly from the view but at the end of it waits for few seconds and gives the error ORA:600. I don't know how to tackle this problem. Can anybody pls guide me to solve this problem.
I am running oracle 22.214.171.124 on win NT (service pack 5). I am also runnig oracle 9iAPS and APACHE on linux servers. We are not using OPS (for info pls).