Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Banner

RE: Oracle Banner

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Mon, 28 Jul 2003 13:54:23 -0800
Message-ID: <F001.005C783D.20030728135423@fatcity.com>


At the risk of stating the painfully obvious--you realize that those 'production' designations refer to the oracle db software itself, and not your use of the db, right?

One other thing to consider would be setting your sql*plus prompt to include the SID of the db to which you are connected. Here's how you can do that: http://www.jlcomp.demon.co.uk/faq/sqlplus_prompt.html

The advantage to that is that the info is always on your screen, long after the banner has scrolled off the edge of the earth. Disadvantages include that you've got to be disciplined to use @connect instead of connect (or else your prompt will be misleading) and that it's no longer easy to copy/paste multi-line sql commands.

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----

Sent: Monday, July 28, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L

Does anybody know if is possible to change the Oracle banner description?

Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production PL/SQL Release 9.0.1.3.0 - Production
CORE 9.0.1.2.0 Production
TNS for Solaris: Version 9.0.1.3.0 - Production NLSRTL Version 9.0.1.3.0 - Production

I would like to identify the environment as development environment instead of production.

Sandro Augusto da Silva
Technology Services & Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522

Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui conteúdo informativo e não transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponíveis: Internet Banking , BankBoston por telefone ou agência/representante de atendimento de sua conveniência. Agradecemos sua colaboração. This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels: Internet Banking , BankBoston by phone or branch/relationship manager at your convenience. Thank you for your cooperation.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Pardee, Roy E
  INET: roy.e.pardee_at_lmco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 28 2003 - 16:54:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US