From: smithari@hotmail.com (Arielle Smith)
Newsgroups: comp.databases.oracle.server
Subject: Re: Disappearing Triggers!
Date: 9 Sep 2002 07:27:58 -0700
Organization: http://groups.google.com/
Lines: 26
Message-ID: <677227cc.0209090627.140b76ca@posting.google.com>
References: <677227cc.0209071142.14576b10@posting.google.com> <3D7A6A3A.7274FA99@AgdF.com>
NNTP-Posting-Host: 208.163.189.92
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1031581678 28845 127.0.0.1 (9 Sep 2002 14:27:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2002 14:27:58 GMT


Hugues Parvillers <Hugues.Parvillers@AgdF.com> wrote in message news:<3D7A6A3A.7274FA99@AgdF.com>...
> Yes but ...
> 
> Arielle , to get help, may be you could tell us what platform and oracle
> version you use ?
> 
> If I'm the only one on the news not to know your platform, sorry about the
> post
> 
> H/P
> 
> Arielle Smith a écrit :
> 
> > I posted a message recently about ORA-03113 errors and got some
> > excellant advice (many thanks), but continuing to track the problem
> > has uncovered some very bizarre happenings.  Following a suggestion, I
> > ran a count of my triggers and found over half of the 60+ missing.  

My apologies!  I'm running Oracle 8.1.7.1.1 on Windows 2000 SP3 on a
Compaq ML530 with dual 1.2GHz XEON processors.  This database has been
rock solid for several years.  I upgraded from 8.0 to 8i on this new
server in March '01 without incident and have not applied any service
packs, upgrades or other since then.  It's actually a bundled app from
a software provider and they are also working madly on the issue, but
in the mean time I have users getting bumped now on a daily basis. 
Thank you!