Send message to all users...

Hi all,

May be this is a stupid question...
Any idea How can I send a message to all Oracle users before to shutdown database?

Thanks:confused:

On UNIX you can send a message (wall - write to all users). On Windows you can use netsend. These are OS functions, not database functions.

Wall sends message to all unix users not just oracle users. I remember sending wall message 7 years ago and it went to everyone in a 43 billion dollar company.

Write a PL/SQL procedure using dynamic sql and UTL_SMTP package to send email to every user of the database provided you know their email addresses. This link has some useful info:

http://www.geocities.com/samoracle/swHowtoSendMail.htm

on Windows:

Spool c:\send_msg.bat
select 'net send '||osuser||' your message goes here....'
from v$session;
spool off

double-click on c:\send_msg.bat and all oracle users will recieve
your meesage.

Quote:

---

Originally posted by kris109
Wall sends message to all unix users not just oracle users. I remember sending wall message 7 years ago and it went to everyone in a 43 billion dollar company.

---

Ah, the origin of spam. I was wondering who first did that.