Thanks, guys. I agree, just wanted some backup in case I missed something.
Rick On Apr 2, 2012 10:16 AM, "Joe Martin D'Souza" <jdso...@shyle.net> wrote: > ** > > If the DB is Oracle (which it must be as this problem is not quite > relevant on MS-SQL), I have heard similar things from Oracle DBA’s as what > Tauf mentioned. > > However I have also heard that Oracle has changed the way things work > around switching the database to case insensitive from 10g onwards. If you > are on 9i below, you might want to be careful. So you may want to double > check with the DBA’s on that one. > > Joe > > *From:* Tauf Chowdhury <taufc...@gmail.com> > *Sent:* Monday, April 02, 2012 9:47 AM > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Changing case sensitivity > > ** Rick, > From talking with DBA's and reading some of BMC's info, changing case > sensitivity at the database level with Oracle is very taxing and you will > experience a huge degradation in performance. I have not tried it so don't > know but I've heard enough people discourage it to not recommend it. It has > something to do with how Oracle performs that function. You are better off > using FTS to index the fields that you don't want to be case sensitive... > that is of course once you get FTS working properly :) > > > On Mon, Apr 2, 2012 at 9:39 AM, Rick Cook <remedyr...@gmail.com> wrote: > >> ** >> >> AR System/ITSM 7.5, Oracle 11g. >> >> Our system is set up as case sensitive, and FTS is installed and >> configured. What would the impact be to changing the setting on an >> existing system? >> >> Rick >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > > > -- > *Tauf Chowdhury* > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
