Take a look at http://www.orafaq.com/node/91#comment-2814
It looks like all the indexes in the instance will need to be recreated as function based indexes that use the nlssort function. It does not look like you can use the ardb.conf file to achieve this. The ardb.conf file entries append a clause to the end of ddl statements for tables and/or indexes. You need to actually modify the contents of the ddl to create a function based index. Remedy has no native capabilities to achieve this. What all this means is that each time you create or trigger the recreation or alteration of an index, you will need to manually drop/create the index. I say manual, but it could be scripted (pl/sql - shell/perl/etc) so that you check for and recreate the indexes using some type of scheduler (e.g., cron). Axton Grams On Tue, Jul 1, 2008 at 11:33 AM, Boucher, Philip <[EMAIL PROTECTED]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
