OraFAQ Forum: Server Administration » Preventing database shutdown by a trigger

Home » RDBMS Server » Server Administration » Preventing database shutdown by a trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Preventing database shutdown by a trigger [message #574747]

Tue, 15 January 2013 10:34

one973
Messages: 10
Registered: January 2013

Junior Member

i mean can i write a trigger to prevent shutdown in certain time
create or replace trigger trig1
before shutdown on database
begin
if to_char(sysdate,'hh24') <16 then
'WHAT IS THE RIGHT THING TO DO HERE??'
.....

[Updated on: Tue, 15 January 2013 10:35]

Report message to a moderator

Re: Preventing database shutdown by a trigger [message #574749 is a reply to message #574747]

Tue, 15 January 2013 10:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>WHAT IS THE RIGHT THING TO DO HERE??'
Fire anyone who shuts down the DB during normal working hours.

Report message to a moderator