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

Thanks,
 
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.
 
Regards
Harshan

 
On 2/11/09, Robertson Lee - lerobe <Lee.Robertson@xxxxxxxxxx> wrote: 

        Hi,
         
        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
         
        TIA
         
        Lee
         
        
************************************************************************
***
        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.
        
************************************************************************
****




-- 
Harshan Eppurath
040-40214832
09392426435 

Other related posts: