Phil,
I am not sure if you are aware of the performance impact a case insensitive
Oracle DB can have on the overall application performance. I have heard at
least couple of scenarios where people were forced to revert back to a case
sensitive setup, when performance issues became unbearable. Hope you have
considered this.
Regards,
--
Shyam
----- Original Message -----
From: "Boucher, Philip" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <arslist@ARSLIST.ORG>
Sent: Tuesday, July 01, 2008 8:33 AM
Subject: Oracle 10G R2 - Case Sensitivity - ITSM 7
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"