-
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
Giani
-
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
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|