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@xxxxxxxxx] 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@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. ************************************************************************ **** -- Harshan Eppurath 040-40214832 09392426435