Re: database shutting down after 24 hours...

I hope I understand your problem but it sounds like there is a trigger set that kicks you off the system. Its been awhile, but I think you can run the command "select trigger_name, status from user_triggers" and you can see if any triggers are on your account. You might have to be a system dba to to this, I am not real sure. Or possiby run "select * from user_triggers". I hope this works

Casey Miller
Georgia State University

"Ann Ominous" <a_ominous_at_yahoo.com> wrote in message news:3D5118BD.91F507B5_at_yahoo.com...
> Hi
> I've inherited some a database, have little DBA experience. Almost 10
> years since I've have to use Oracle in anger.
> Current setup is Oracle 8.1.6 on Windows NT Server.
> Every morning the database is not accessible around 10am each morning
> The following shows up in the event log several times
> "Instance freddb database has been terminated."
>
> This database is used by a development team. Initially was configured
> with archive logging but this was disabled as the database contents are
> not important and others reported problems with disk space. Freddb has
> been spread across 3 disks with the OS and database software on another
> HDD.
> Oracle has moved on quite a bit since my days of using version 4, so I
> just wanted to check what features could possibly be causing the problem
> above. Cannot find any OS scheduled jobs.
>
> TIA
> -ao-
>
Received on Sun Aug 11 2002 - 22:34:23 CDT