It's not so much an Oracle limitation these days; Remedy is just not capable of leveraging it properly, unless you want to run the system without using any indexes.
Axton Grams On Thu, Sep 4, 2008 at 5:02 PM, Pierson, Shawn <[EMAIL PROTECTED]>wrote: > ** > > It is possible to set up a database to be case insensitive in Oracle. The > Remedy limitation is really an Oracle limitation. By default, Oracle is > case sensitive, and your DBA should either know or be able to figure out how > to make your ARSystem database case insensitive. However, as far as I know, > this has to be set up from the beginning. > > > > As far as the Active Directory thing, I agree that it's a major problem and > that BMC should fix it. Our users don't understand why they can log in > using all caps on the network and not in Remedy. > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Marty.Thorin > *Sent:* Thursday, September 04, 2008 3:44 PM > *To:* [email protected] > *Subject:* Can Remedy run case insenitive? > > > > ** > > Good afternoon. > We will be moving from Remedy 6 on Sybase to Remedy 7 on Oracle. > (Database politics -- let us not go there.) > > We are forever being bit by the case insensitivity of Active Directory. > People try to login in upper case. Active directory allows them to do so. > But everything in Remedy is case sensitive so they do not get a home page -- > they get a blank screen. > > As all of our account data comes from case-insensitive sources, I was > wondering if we could tell the new Oracle database to be case-insensitive. > I would like to hear what the group thinks and what the experience has been. > > Have a nice day, > Thorin Marty > We Energies > Milwaukee, WI > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > Private and confidential as detailed > here<http://www.sug.com/disclaimers/default.htm#Mail>. > If you cannot access hyperlink, please e-mail sender. > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
