Home » RDBMS Server » Server Administration » Sending messages
Sending messages [message #52238] Wed, 10 July 2002 11:02 Go to next message
Alan
Messages: 68
Registered: October 1999
Member
Does Oracle8i/9i have functions that allow the DBA to send messages to connected users? For example: warning users to logoff as that DBA can shutdown the database? thx.

Report message to a moderator

Re: Sending messages [message #52239 is a reply to message #52238] Wed, 10 July 2002 11:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If any of such kind is available, I WOULD LOVE THAT.
All we can do is , create a before shutdown trigger,
to flag something to OS ( create a file or something like that).
Anyhow the Actual warnng can be sent only by the OS.

Report message to a moderator

Re: Sending messages [message #52264 is a reply to message #52239] Thu, 11 July 2002 09:20 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Your client could be anything -- Web, sqlplus, C (OCI), JDBC, ODBC etc. so the client needs to be listening for the message.

Report message to a moderator

Previous Topic: Enabling trace for single user
Next Topic: dbms version??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 07 14:28:33 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.