Lisa, Yes, that is true. However, I believe you can use select table_name from user_tables@<link <[EMAIL PROTECTED]> name> and have it work. But I am not 100% on that one.
Brian On Thu, Mar 27, 2008 at 3:10 PM, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > ** Sorry, stupid question, when I use the query select table_name from > user_tables order by 1, this will only give me the AR System database > tables, not the ones that are on another oracle database. > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, March 27, 2008 4:05 PM > *To:* [email protected] > *Subject:* Re: View Forms > > ** Ok, I just did this and this table it not in the list. How can I get > this table in the list? Is there a setting on preferences or something that > I'm missing? > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > *Sent:* Thursday, March 27, 2008 3:59 PM > *To:* [email protected] > *Subject:* Re: View Forms > > ** Thanks, I'm going to try this....Everything points to the fact that > this should work. > > I'll let you know! > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk > *Sent:* Thursday, March 27, 2008 3:51 PM > *To:* [email protected] > *Subject:* Re: View Forms > > ** If you can log into the database as ARADMIN and see the tables then you > should be able to create the Remedy view. It would seem to me that you > might just want to create a simple form that runs the query " u " so that > you can see the list of tables (and any odd naming) that are available to > the Remedy server. Often times this is a simple way to make sure you get > the name right. If you run an active link with a set fields / sql command > and make that your sql statement, you can then populate a field with the > table name so that you can just cut and paste. > > > On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W < > [EMAIL PROTECTED]> wrote: > > > ** If they are not owned by aradmin, are you including the owner name? > > > > Fred > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > > *Sent:* Thursday, March 27, 2008 2:29 PM > > > > *To:* [email protected] > > *Subject:* Re: View Forms > > > > ** These are not ARS tables. Just plain old tables from an Oracle > > database. Our DBA was able to log into SQL developer with the aradmin > > account and see these tables just fine. For some reason, my admin tool must > > not be using the aradmin account for view forms? I'm connected to our ARS > > database so it's working in that respect..... > > > > These are not owned by aradmin either, but it is in the permission > > group. > > > > <sigh> > > > > > > Lisa > > > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk > > *Sent:* Thursday, March 27, 2008 1:44 PM > > *To:* [email protected] > > *Subject:* Re: View Forms > > > > ** Not true. She doesn't need the T table. First off, if it isn't an > > ARS table there might (probably won't) be a T table unless it was created > > manually. However, you can still use the view instead. If it is a Remedy > > created table, then the view name has a specific format. All none > > alphanumeric characters are replaced with an underscore. Also, view names > > in an Oracle (and I assume the others) database is only 30 characters long > > if Remedy created the view. So if your view (form) name is longer than 30 > > characters just drop the exceeding characters. There is one other caveat in > > case you have more than one view name that is the same until past the 30 > > character limit. The last letter (number 30) is replaced by a sequential > > number starting with the second form and incrementing for each form. Check > > out my examples but please don't name your forms as such or think that I > > have mine named like this. > > > > Form Name: CTM:People Site AP:Administration Join > > View Name: ctm_people_site_ap_administrat > > > > Form Name: CTM:People Site AP:Administration Role Join > > View Name: ctm_people_site_ap_administra2 > > > > Please only use this as an example. I didn't verify my thoughts from > > off the top of my head. > > > > Also, if you want the list of views just run this: select view_name from > > user_views order by 1 > > > > That will work in an Oracle db for sure. > > > > Also, I have not found a case sensitivity for form or field names when > > writing SQL queries. > > > > HTH, > > > > Brian Goralczyk > > > > On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote: > > > > > Yes, if it's owned by aradmin, she'll need the T table. > > > > > > Drew > > > > > > On Thu, 27 Mar > > > 2008, Nisha Ramtri wrote: > > > > > > > Lisa, > > > > > > > > This error normally occurs when the table name that is being > > > provided is > > > > different from the actual name in the db. Check for the name, > > > spelling of > > > > the table in the database. The table name is case sensitive also. > > > Hence take > > > > care of that as well while providing the name of the table. Also > > > make sure > > > > that the table is in the aradmin d/b. Hope that helps. > > > > > > > > Rgd, > > > > Nisha. > > > > > > > > > > > > On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > > > >> > > > >> ** Also, I am typing the table name in CAPS. > > > >> > > > >> > > > >> Lisa > > > >> > > > >> > > > >> ------------------------------ > > > >> *From:* Action Request System discussion list(ARSList) [mailto: > > > >> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > > > >> *Sent:* Thursday, March 27, 2008 12:05 PM > > > >> *To:* [email protected] > > > >> *Subject:* View Forms > > > >> > > > >> > > > >> ** > > > >> > > > >> I'm trying to create a View Form that connects to a table on an > > > Oracle > > > >> database and I'm getting the error message: > > > >> > > > >> "Requested database table not found. Please check the spelling > > > (table > > > >> name is case-sensitive) (ARERR 481)." > > > >> > > > >> The table has aradmin added to the permission list. Is there > > > anything > > > >> else I'm missing? > > > >> > > > >> AR Server 7.01 Patch 6 > > > >> Windows 2003 app Server > > > >> > > > >> *Lisa Kemes * > > > >> AR System Developer > > > >> Tyco Electronics > > > >> 717-810-2408 tel > > > >> 717-810-2124 fax > > > >> [EMAIL PROTECTED] > > > >> > > > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > > > Are" > > > >> html___ > > > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > > > Are" > > > >> html___ > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > > Answers Are" html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > Answers Are" html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
