RE: Grant select on view returns 03113 error

From: Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
Date: Wed, 11 Feb 2009 15:31:24 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F815216EE5_at_sunmsx01.Corp.Acxiom.net>

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_at_gmail.com] 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_at_acxiom.com> 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 

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 11 2009 - 09:31:24 CST