Actually, I am looking further into this.. I think OE is needed.. Oracle using this for security side.. if he is Hardening the server.. check this http://www.oracle.com/technology/deploy/security/pdf/twp_security_checklist_db_database.pdf
I am looking around at the rest.. On 12/8/06, Mark Powell <[EMAIL PROTECTED]> wrote:
Thanks, Zandi. I know ARS creates background schemas of its own like ARSCHEMA and FILTERS... etc., and since it functions across several DB platforms, I didn't think it would have total reliance on Oracle default schemas. But, if it does make use of them, say to improve performance when on Oracle, I didn't want to break it. We are using a testbed for the first pass, so we shouldn't do too much damage either way. I've also asked Remedy Support, and will post an update on their response. You were much quicker, and I know you've done installs many times over the years! Thanks!! -Mark Powell [EMAIL PROTECTED] ------------------------------- On 12/8/06, patrick zandi <[EMAIL PROTECTED]> wrote: > ** > Mark, > Not that I know of..Remedy using ARadmin tables, and any links that you > need.. > you could use remedy to access the scott / hr tables for testing purposes.. > your choice.. > like a Testbed of sorts.. This way you don't mess with your prod data.. who > cares about scott's tables.. > > But there is additional functionality that you can use with some of these.. > Like if you wanted an oracle application to access your remedy tables.. and > build in some additinal View functionality or report's.. some of those > below.. (if I remember correctly) will be needed.. > > > On 12/8/06, Mark Powell <[EMAIL PROTECTED]> wrote: > > > > Hello list: > > > > We are in the process of upgrading Oracle to support an upgrade of > > ARS. We are moving from Oracle 9i to Oracle 10gR2 and then will > > upgrade ARS from 5.1.2 to 7.0.1. The question the DBA presented me > > is... does ARS make use of any of the following Oracle default > > schemas, or can they be removed to keep things clean? > > > > CTXSYS > > HR > > MDSYS > > ODM > > ODM_MTR > > OE > > OLAPSYS > > ORDPLUGINS > > ORDSYS > > OUTLN > > PM > > QS > > QS_ADM > > QS_CBADM > > QS_CS > > QS_ES > > QS_OS > > QS_WS > > SCOTT > > SH > > WKSYS > > WMSYS > > XDB > > > > Does ARS (5.1.2, 6.3 or 7.0.1) use any of these when residing on > > Oracle?? We're on Solaris 9 if that makes any difference. > > > > Thanks for your help! > > > > -Mark Powell > > [EMAIL PROTECTED] > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgARSlist:"Where > the Answers Are" > > > > > > -- > Patrick Zandi __20060125_______________________This posting > was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
