RE: Oracle Banner

Yes it is. We actually had to do it for a canned app that checked the exact version of the database...for no apparent reason. The app would only run on 8.1.6 and we were running 8.1.7...so we just created a table with the exact same structure as v$_version and update the table to reflect 8.1.6. We then just pointed the public synonym (v$version) to the dummy table.  

This is probably not recommended but we tested it on our development database and have had no ill effects.  

Mladen...please have mercy on me. :-) ...it isn't the same as messing with the data dictionary or screwing with objects owned by sys.  

-----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:
<http://www.bankboston.com.br> Internet Banking ,
<http://www.bankboston.com.br/bpt> 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:
<http://www.bankboston.com.br> Internet Banking ,
<http://www.bankboston.com.br/bpt> 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: Chris Stephens
  INET: ChrisStephens_at_affina.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).