Lisa, View Forms using synonyms are working only if the owner of the underlying object is the same as the owner of the synonym. IMHO this is a bug.
Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Kemes, Lisa Gesendet: Montag, 1. Juni 2009 02:59 An: arslist@ARSLIST.ORG Betreff: Re: View Forms and Synoyms.... SQL client works just fine.... We need to know if others are creating view tables using either a public synonym or a synonym owned by ARAdmin instead of using the table name? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, May 27, 2009 11:48 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms.... So what do the sql statements below return when run from your sql client? Are synonyms available in all_tab_columns? If they are not then you are probably out of luck using synonyms. Axton Grams On Wed, May 27, 2009 at 11:27 AM, Kemes, Lisa <lisa.ke...@tycoelectronics.com> wrote: > Thanks Fred. I tried this, but I'm still getting the error. (Even > though it's not captured on the SQL logs for some reason) > > */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and > owner = 'DCC' > */OK > */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' > and owner = 'DCC' > */OK > > > Lisa > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W > Sent: Wednesday, May 27, 2009 12:12 PM > To: arslist@ARSLIST.ORG > Subject: Re: View Forms and Synoyms.... > > Try adding in the owner of your synonym. > > Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch > 007 on Solaris w/Oracle 10i (Remote DB) > > Attempting to create a View Form on "USER_VIEWS" > > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where > table_name = 'USER_VIEWS' and owner = 'ARADMIN' > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:49:37.0325 */OK <SQL > <Queue: Admin> <Client-RPC: > 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0327 */ SELECT > table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = > 'ARADMIN' > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:49:37.0574 */OK <SQL > <Queue: Admin> <Client-RPC: > 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0575 */ Error - can't > find table USER_VIEWS (owner = ARADMIN). > > Attempting to create a View Form on "SYS.USER_VIEWS" > > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where > table_name = 'USER_VIEWS' and owner = 'SYS' > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:51:30.7696 */OK <SQL > <Queue: Admin> <Client-RPC: > 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7699 */ SELECT > column_name,data_type,data_length,data_precision,data_scale from > all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' > <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed > May 27 2009 10:51:30.7771 */OK > > > Fred > > ________________________________________ > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa > Sent: Wednesday, May 27, 2009 10:14 AM > To: arslist@ARSLIST.ORG > Subject: Re: View Forms and Synoyms.... > > Yes it does work from the SQL Client. Sorry, I should have specified > that..... > > Lisa > > ________________________________________ > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza > Sent: Wednesday, May 27, 2009 11:01 AM > To: arslist@ARSLIST.ORG > Subject: Re: View Forms and Synoyms.... > > I thought I'd ask you the very obvious question... Can you query the view > form as aradmin from the SQL client when logged in as aradmin using that same > view name??? > > Joe > ________________________________________ > From: "Kemes, Lisa" <lisa.ke...@tycoelectronics.com> > To: arslist@ARSLIST.ORG > Sent: Wednesday, May 27, 2009 10:44:30 AM > Subject: View Forms and Synoyms.... > > Got a ticket into BMC, we are having problems using Synonyms for our View > Forms. Getting "Requested Database table not found. Please check the > spelling (table name is case-sensitive) ARERR 481." > > We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? > > Oracle 10i > Windows 2003 > > Lisa Kemes > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-810-2124 fax > lisa.ke...@tycoelectronics.com > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"