Re: Queries don'twork any more - urgent!

This sounds like some data has changed which now prevents the query from finding matching rows... Take the query and remove all where clause elements
to see if there is basic data present... then add them in one after the other

(as appropriate) to see where it breaks down...

I'd try this before jumping in all over some fault in the engine...

randy

kev wrote:

> I already tried shutting it down and starting it up again, that made no
> difference!
>
> - Kev
>
> sergey_s_at_my-deja.com wrote:
>
> > I beleive I had the same problem a while back.
> > The only thing that worked for me relatively
> > quickly at the time was shutdown/startup at the
> > svrmgrl prompt.
> >
> > I realize this is not exactly what you would
> > want to do with any live system (development,
> > much less production). In my case, I was the
> > only one using it.
> >
> > Sergey
> >
> > In article <393B01EE.140F053B_at_markandlard.com>,
> > kev <kev_at_markandlard.com> wrote:
> > > Hi,
> > >
> > > I'm using 8.1.5 on Red Hat 6.1.
> > >
> > > Certain (similar) queries have stopped returning any results. They
 were
> > > working fine, and then suddenly stopped. I'm 99% certain I have done
> > > nothing which may have caused this.
> > >
> > > Where the hell do I start to find out what's wrong?
> > > I'm at home and so don't have Oracle Support's 24/7 support phone
 number
> > > (England) with me. If anyone could remind me of it (mail me direct) I
> > > can ring them.
> > >
> > > thanks,
> > >
> > > - Kev
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Tue Jun 06 2000 - 00:00:00 CDT