RE: Grant select on view returns 03113 error

  • From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
  • To: "harshan eppuram" <harshan.eppuram@xxxxxxxxx>
  • 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@xxxxxxxxx] 
Sent: 11 February 2009 15:26
To: Robertson Lee - lerobe
Cc: oracle-l
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@xxxxxxxxxx> wrote: 

        Oracle 10.2
        AIX 6
        Really weird this one, googled and metalinked with no joy. Hope
someone 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.

        Any ideas
        The information contained in this communication is confidential,
        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
        hereby notified that any dissemination, distribution or copying
of this
        communication is strictly prohibited.
        If you have received this communication in error, please resend
        communication to the sender and delete the original message or
any copy
        of it from your computer system.
        Thank You.

Harshan Eppurath

Other related posts: