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