thanx sunil, I got a lot more than I was looking for..... On 6/15/05, Sunil Bhola <oraclebhola@xxxxxxxxx> wrote: > > Hi Onkar, > I would like to refer you a link, please check this link. Hope that will > help you :-) > http://www.psoug.org/reference/sys_context.html > Regards, > Sunil Bhola > > *Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>* wrote: > > hi oracle gurus, > We have got one dramatic situation where one of our remote dba shutdown > the > database, which was not supposed to be done. Now I have been asked to stop > > these sort of situation in future. I know in this situation I need to use > trigger(on database before shutdown) but the problem is I dont know how to > > check the machine name from within the trigger from where the shutdown > command has been invoked... > Any suggestion??????? > -- > Thanks & Regards, > T. Onkar Nath > Ph : +91-9826728111(Cell) > to_onkar@xxxxxxxxx > onkarnath.tiwary@xxxxxxxxx > > -- > //www.freelists.org/webpage/oracle-l > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l