RE: Grant select on view returns 03113 error
- From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
- To: <mark.powell@xxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Feb 2009 16:40:36 -0000
BINGO mate....
Followed the instructions in the doc and it worked. Bizarre !!
Thanks to all who responded and offered advice.
Regards
Lee
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: 11 February 2009 17:24
To: oracle-l
Subject: RE: Grant select on view returns 03113 error
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.
************************************************************************
*
Other related posts:
