RE: Grant select on view returns 03113 error
Date: Wed, 11 Feb 2009 15:31:24 -0000
And I am aware of that but we have been seeing this for quite some time, thats why I thought I would ask to see if anyone else has seen it.
From: harshan eppuram [mailto:harshan.eppuram_at_gmail.com]
Sent: 11 February 2009 15:26
To: Robertson Lee - lerobe
Subject: Re: Grant select on view returns 03113 error
ORA-03113 is the most common error one could see in oracle. It can be because of 100s of reasons. I would try it again.
On 2/11/09, Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com> wrote:
Oracle 10.2 AIX 6 Really weird this one, googled and metalinked with no joy. Hopesomeone has seen this before.
Got a couple of rather large complex views. When I try to recompile or grant select on them the following happens
grant select on <view_name> to <user>
Error at line 1
ORA-03113: end-of-file on communication channel
Script Terminated on line 5.
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
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.
-- Harshan Eppurath 040-40214832 09392426435 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 11 2009 - 09:31:24 CST