Thanks Axton. That helps quite a bit. -Rob ________________________________
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Sunday, January 28, 2007 10:27 AM To: [email protected] Subject: Re: Oracle View Forms ** If your aradmin account has 'select any dictionary' permissions, you can log into your remedy oracle instance and see if what you are providing for the schema/table match what's out there using this: If it's a table: select owner, table_name from all_tables where owner = 'OMS' If it's a view: select owner, view_name from all_views where owner = 'OMS' If your aradmin account does not have this privelage, you can attempt to describe the table using your aradmin account from sql*plus: desc OMS.OI_END_USER_VW If all of the above fail to show the table/view you are attempting to access, then it either doesn't exist (first two options), or you don't have permissions (third approach). Axton Grams 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___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
