RE: Grant select on view returns 03113 error
Date: Wed, 11 Feb 2009 15:42:44 -0000
No, it doesn't :-(
Same thing again.
The only thing that sometimes works is dropping and recreating the view
From: Bartek [mailto:bpawlows_at_gmail.com] Sent: 11 February 2009 15:33
To: Robertson Lee - lerobe
Subject: Re: Grant select on view returns 03113 error
This happens to me the sqlplus loses a connection with db. Login again should help.
On Wed, Feb 11, 2009 at 4:22 PM, Robertson Lee - lerobe
> Oracle 10.2
> AIX 6
> Really weird this one, googled and metalinked with no joy. Hope
> seen this before.
> Got a couple of rather large complex views. When I try to recompile or
> 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, is
> intended only for the use of the recipient named above, and may be
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of
> 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
> of it from your computer system.
> Thank You.
Received on Wed Feb 11 2009 - 09:42:44 CST