RE: Oracle Banner

[Chris Stephens]

Actually...went to look and see exactly how we did this...(it was quite a while ago)...� We didn't drop the v$version public synonym.� We created a private synonym with the same name in the schema the app ran in and had it point to the new dummy table.       -----Original Message----- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Subject: 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.  J  ...it isn't the same as messing with the data dictionary or screwing with objects owned by sys.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Banner   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.