SQL*Plus Worksheet prompt

From: Herring Dave - dherri <david.herring_at_acxiom.com>
Date: Fri, 17 Dec 2004 14:58:06 -0600
Message-ID: <433A07749711884D8032B6A0AB11526205B7CA66@conmsx07.corp.acxiom.net>

Folks,  

Is there any way of automatically having the instance displayed somewhere within SQL*Plus Worksheet window? I have a lot of DBs to manage and while its convenient to run everything from OEM console, each worksheet window looks the same. I've tried updating
$ORACLE_HOME/sysman/config/sqlplusWorksheetInit.sql to set sqlprompt, but, as the comments say, that doesn't work.  

Any clues how to help identify what instance each window is connected to?  

Dave Herring, DBA

Acxiom Corporation

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 17 2004 - 15:08:40 CST