DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Send message to all users...

  1. #1
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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

  4. #4
    Join Date
    Nov 2000
    Location
    Potomac, Maryland
    Posts
    85
    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.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width