Oracle 9i to 10g upgrade issues?
We are running ARS 6.3 patch 20 and need to upgrade our database to Oracle 10g from 9i. When you do this, you can't install Oracle on top of the previous version. Now that we have Oracle upgraded, remedy can't find the database. Has anyone had issues with this kind of an upgrade? Apparently Remedy hardcodes Oracle information that we will need to change. Any ideas? Thanks! Melissa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Performance issues with turning off case sensitivity?
I read somewhere that if you turn off case sensitity in Oracle, you could have perform issues due to some kind of an index thing. Has anyone else experienced this? We are in the process of migrating to 10g and have considered turning this off, but if it's going to cost performance, we may need to rethink this. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are