Hi, We are currently setting up a new ARS 7.1 - ITSM 7 system on an Oracle 10G R2 database and will require the database to be case insensitive.
I've read several posts on here about Oracle and case sensitivity but I'm not clear on exactly what needs to be done. I've found that the following session variables need to be set: ALTER SESSION SET NLS_SORT=BINARY_CI ALTER SESSION SET NLS_COMP=LINGUISTIC But do we need to do anything else such as creating additional indexes? Also can we make these changes after the initial set up or do they need to be applied before the installation begins. If anyone else has done this recently I'd really like to hear their experiences. Thanks Phil Boucher Remedy Technical Architect _____________________________ Logica - Releasing your potential 400 Park Avenue, Aztec West Almondsbury Bristol BS32 4TR UK T: +44 (0) 1179 017661 (direct) E:[EMAIL PROTECTED] www.logica.com Logica UK Limited Registered in England and Wales (registered number 947968) Registered office: Stephenson House, 75 Hampstead Road, London NW1 2PL, United Kingdom This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"