I'm thinking that since I have do do this and am no longer on a remote DB instance that I might as well just recode the Al's and filters with direct SQL anyway. That's one less step that recreating the View Forms, the having to repaint all the workflow anyway. Thanks, Frank -Rob
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Sunday, January 28, 2007 9:50 AM To: [email protected] Subject: Re: Oracle View Forms ** Was the name in upper case letters? I was playing with the View form stuff for a little bit and was watching SQL logs to see what exactly it was doing. One thing you might try is turning on SQL logging and create a new view form. You will then be able to see the exact SQL it runs. I saw stuff about selecting from the all_tables and all_columns tables using the provided [EMAIL PROTECTED] vlalue. I also thought more about this and realized that if you're recreating all of the view forms, that is like recreating a regular form. If you have work flow tied to that form it will also need to also be created. Any table fields using those views would have to be reconstructed. A ton of work for 80 forms! So, I started playing with trying to just change the DB Link value. I was able to recreate the underlying (T???) view with the a new DB Link value. The existing view form used the new DB Link and pointed to the new database. This is probably not supported by BMC but might be a quick way to get you back up and running. On 1/28/07, Tucker, Rob <[EMAIL PROTECTED]> wrote: ** Yes, aradmin has selected permissions against everything in those schemas. About 80 view forms :( ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Sunday, January 28, 2007 8:38 AM To: [email protected] Subject: Re: Oracle View Forms ** Does the ARSystem user have select access against that table? How many views do you have to redo? On 1/28/07, Tucker, Rob < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: ** I hope one of you good folks is working weekends :) I originally had the remedy database in it's own instance of oracle. For reasons knows only to the powers that be, we have moved the tablespace from it's own instance to a shared instance. The system runs fine except for all my view forms that previously used a db link to pull data. The view forms were built similar to: [EMAIL PROTECTED] where PHNXP.WORLD was the db link. Now that I am sharing a instance with the data I previously accessed using the dblink and since the dba's tell me a dblink cannot share the name as the instance, I have to redo the view forms. Trouble is when I attempt to create a view form as follows: OMS.OI_END_USER_VW I get this error: Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). You'll note that the schema.table name are identical to before and I have verified them as being correct. What am I missing? Thanks! -Rob ____________________________________________ Rob Tucker New Edge Networks ARS Administration and Development [EMAIL PROTECTED] Vancover,Washington tel: 360-759-9670 fax:360-693-9997 __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
