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

I called Oracle Tech Support and was directed to download the 7.3.3.60 patchset from the following location:
 ftp://192.86.154.96/server/WGT_TECH/server/windowsNT/73 patchsets/73360.

The patchset solved the problem. According to the Oracle Tech Support, the problem was caused by creating view from other views, which appeared to be a situation not well handled previously in Oracle.

Thanks to Rick Wessman <rwessman_at_us.oracle.com>

                 Pat MInnis <pminnis_at_maverick.net>
                 zapatoa_at_email.msn.com

for responding to my post.

Edward Jiang

> > In article <01be2ee3$988799b0$5501a8c0_at_edj>,
> > "ejiang" <ejiang_at_thru-put.com> wrote:
> > > I was debugging sql queries using the Oracle SQL Worksheet in the
Oracle
> > > Enterprise Manager v. 1.3.5. The operating system is Windows NT 4.0.
> > > When I enter SELECT * FROM VIEW; SQL Worksheet prints the records
without
> > > problem.
> > > Somehow, if I specify one or more fields in the query ( e.g. SELECT
QTY
> > > FROM VIEW; or SELECT VIEW.QTY FROM VIEW; ),
> > > The following error message appears:
> > >
> > > ORA-03113:end-of-file on comunication channel
> > >
> > > The connection to the database is also lost.
> > >
> > > Your advice on the cause and/or solution to the problem is greatly
> > > appreciated.
> > >
> > > Edward
Received on Wed Jan 27 1999 - 20:36:20 CST