RE: Grant select on view returns 03113 error
Date: Wed, 11 Feb 2009 12:23:53 -0500
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
CREATE VIEW RAISES ORA-03113 ON SESSION LEVEL AND 7445[QCDLGTD] WITHIN ALERT Also see ORA-07445 [qcsfgrd] Can Occur While Selecting From View
If neither applies then it might be time to open a SR.
- Mark D Powell --
Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robertson Lee - lerobe
Sent: Wednesday, February 11, 2009 11:38 AM To: nigel.cl.thomas_at_googlemail.com 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, dugaround in thetrace file as well but still no luck.
From: Nigel Thomas [mailto:nigel.cl.thomas_at_googlemail.com] 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-3113has 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.
2009/2/11 Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
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
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.
* Received on Wed Feb 11 2009 - 11:23:53 CST