This was a 9./2.0.8 problem but if the view in question references a SYS owned object check out the following My Oracle Support document #602111.1 CREATE VIEW RAISES ORA-03113 ON SESSION LEVEL AND 7445[QCDLGTD] WITHIN ALERT Also see ORA-07445 [qcsfgrd] Can Occur While Selecting From View #373435.1 If neither applies then it might be time to open a SR. -- Mark D Powell -- Phone (313) 592-5148 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robertson Lee - lerobe Sent: Wednesday, February 11, 2009 11:38 AM To: nigel.cl.thomas@xxxxxxxxxxxxxx Cc: oracle-l Subject: RE: Grant select on view returns 03113 error Hi, yep, got a 7445 error but that doesn't give me anything, dug around in thetrace file as well but still no luck. ________________________________ From: Nigel Thomas [mailto:nigel.cl.thomas@xxxxxxxxxxxxxx] Sent: 11 February 2009 16:35 To: Robertson Lee - lerobe Cc: oracle-l Subject: Re: Grant select on view returns 03113 error Lee Is there anything in the alert log? As you may know, ORA-3113 has been a symptom of countless bugs over time (especially with views, I recall); armed with more info you might be able to construct a more useful Metalink query. Regards Nigel 2009/2/11 Robertson Lee - lerobe <Lee.Robertson@xxxxxxxxxx> grant select on <view_name> to <user> Error at line 1 ORA-03113: end-of-file on communication channel ************************************************************************ * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************ *