RE: Grant select on view returns 03113 error

From: Robertson Lee - lerobe <>
Date: Wed, 11 Feb 2009 16:37:45 -0000
Message-ID: <>

Hi, yep, got a 7445 error but that doesn't give me anything, dug around in thetrace file as well but still no luck.

From: Nigel Thomas [] Sent: 11 February 2009 16:35
To: Robertson Lee - lerobe
Cc: oracle-l
Subject: Re: Grant select on view returns 03113 error


Is there anything in the alert log? As you may know, ORA-3113 has been a symptom of countless bugs over time (especially with views, I recall); armed with more info you might be able to construct a more useful Metalink query.

Regards Nigel

2009/2/11 Robertson Lee - lerobe <>

        grant select on <view_name> to <user>

        Error at line 1

        ORA-03113: end-of-file on communication channel

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.

Received on Wed Feb 11 2009 - 10:37:45 CST

Original text of this message