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]> 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
