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
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
_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
Take an SQL log and see what SQL the AR System throws to the database server at
the time you get that error.
Joe
From: "Kemes, Lisa"
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 27, 2009 12:27:21 PM
Subject: Re: View Forms and Synoyms
Thank
That won't work because ARAdmin is the owner of the synonym.
--Original Message--
From: Lisa Kemes
To: Arslist
ReplyTo: Arslist
Subject: Re: View Forms and Synoyms
Sent: May 27, 2009 12:27 PM
Thanks Fred. I tried this, but I'm still getting the error. (Even though it'
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:
x27;USER_VIEWS' and owner = 'SYS'
/* 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 Form
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"
To: arslist@A
009 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 though
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
Li
10 matches
Mail list logo