RE: Grant select on view returns 03113 error

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

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

---

---

>

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

Received on Wed Feb 11 2009 - 09:42:44 CST