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 <[email protected]> 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 * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
