I didn't know there was a problem with Oracle 11. As long as you are using the Oracle 10g client binaries you should be able to have the db on Oracle 11. Just tell Remedy that Oracle is on a remote machine. This would be the same sort of situation that 6.3 had using Oracle 10 (6.3 required the Oracle 9 client binaries) Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jill E Sent: Thursday, February 28, 2008 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: Updating view forms - RESOLVED ** Thanks all for the responses. I talked to our DBA who dropped the synonym MYSCHEMA.MYVIEW (named so because it used to be a view) and recreated it as a view of the MYSCHEMA DB over the link and the error in Administrator has ceased. For both aradmin and non-aradmin (a.k.a. MYSCHEMA) synonyms, Administrator would not load the table, even to create a new view form. It would load table only for the full [EMAIL PROTECTED] I did find a bug fix reported for version 6.3 related to using a synonym, so perhaps this related. Of course, I wouldn't be considering any of this at all if ARS would just support Oracle 11 so the Remedy DB could have been upgraded along with the rest of our application databases. :-D Thanks again for the advice. Jill Anderson On Thu, Feb 28, 2008 at 8:39 AM, Tucker, Rob <[EMAIL PROTECTED]> wrote: ** My memory isn't what it used to be, but I believe you can change the view pointers at the database level by changing the tablename in the SCHEMA_VIEW table, then restarting the system. You'll see the underlying tables for your view fields in this table. No Warranty Implied! :) Rob Tucker New Edge Networks ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 27, 2008 3:09 PM To: arslist@ARSLIST.ORG Subject: Re: Updating view forms ** I don't know of a way to change the Remedy view location other than exporting to a def, modifying the def, deleting the form and re-importing from the modified def. Importing in place (without deleting the form) might work. Have you tried creating a local Remedy db view of the remote data. Basically drop the synonym and do: Create or Replace View MYSCHEMA.MYVIEW as select * from [EMAIL PROTECTED]; No changes to Remedy will then be necessary. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jill E Sent: Wednesday, February 27, 2008 5:00 PM To: arslist@ARSLIST.ORG Subject: Updating view forms Greetings, In an ARS 7.0.1 / RHEL4 64bit / Oracle 10g environment, I created a view form to look at a view of another schema in the same database as Remedy. That schema was moved to another Oracle database so now a DB link must be employed. This is fine except that I need to update the view form in ARS so that it knows to look in the new location. How can I update the view form definition to look at a different database location? Specifically, I want to change Form Properties > View Information > Table Name value from MYSCHEMA.MYVIEW to [EMAIL PROTECTED], Field Properties > Database tab > View Information > Table value, or use some other means to update the view form to use a new table name value. I tried a workaround by creating a synonym, which works fine in SQLPlus for running queries as aradmin like "select * from MYSCHEMA.MYVIEW where id='foo'" but each time I open the view form in Remedy Administrator, the error "Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481)" is reported and I am not able to get AR to use the synonym, even to create new view form, like I am with SQLPlus. I've found old bugs relating to synonyms, but I am not tied to using this approach to solve the problem anyway. Thanks for any advice you can offer! Jill Anderson __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
