RE: Grant select on view returns 03113 error

No, it doesn't :-(

Same thing again. 

The only thing that sometimes works is dropping and recreating the view 


-----Original Message-----
From: Bartek [mailto:bpawlows@xxxxxxxxx] 
Sent: 11 February 2009 15:33
To: Robertson Lee - lerobe
Cc: oracle-l
Subject: Re: Grant select on view returns 03113 error

Hi,

This happens to me the sqlplus loses a connection with db.
Login again should help.

cheers, Bartek

On Wed, Feb 11, 2009 at 4:22 PM, 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.
>
************************************************************************
****
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: