Just an FYI
Oracle tables names, view names, columns names, functions, etc are NOT case
sensitive. Oracle data is. So, mixing case on view names is not important
unless the view name is being treated as data (as in an Oracle dictionary
table) where it is indeed stored in uppercase.
So, using a non-linked database query as an example:
select company from com_company
is entirely equivalent to
SeleCT COMpany from COM_company
So,
seLECt disTINCT table_nAMe from all_tAB_columns where oWNer = 'ARADMIN' and
taBLe_name like 'A%'
will return all ARS tables and views starting with 'A'
and
seLECt disTINCT table_nAMe from all_tAB_columns where oWNer = 'ARADMIN' and
taBLe_name like 'a%'
will return no records.
BTW if you do not have an Oracle client, queries on this table
(all_tab_columns) is a good way to get a "DESCRIBE".
Cheers
Ben
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: February-02-12 22:59
To: [email protected]
Subject: Re: Create a View form of a remote oracle DB on ARSystem (MS SQL)
I believe it is Case sensitive. All Oracle table and view names are
uppercase. Try link.db.OWNER.TABLE
You may find it cleaner to create a local database view that does the remote
query. Then you should not have to worry about the case sensitivity from
Remedy.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Reiser, John J
Sent: Thursday, February 02, 2012 3:50 PM
To: [email protected]
Subject: Create a View form of a remote oracle DB on ARSystem (MS SQL)
Hello Listers,
MS SQL 2005 on a SAN
MS Windows 2003 Enterprise
AR System 7.6.03 Build 001
Our system connects to a remote Sybase DB via the DB Link for ARS Croom
Consulting.
The Sybase DB is being replaced by an Oracle DB.
We only need to read data so I am trying to make the oracle connection with
a View form.
The MS SQL dba created a Linked server to the Oracle DB and confirmed the
connectivity.
In the View form should I use the MS SQL connection string or an Oracle
connection string?
<linkname>.<db_name>.<owner>.<table> or <db_name>.<table>@<linkname>
The value that I tried to load was the ORAORQ10.propmgt.propmgt.equipment.
That gives an ARERR 552 message
I have also tried propmgt.equipment@ORAORQ10 That gives ARERR 481 but I'm
not sure if the "table not found" is because of case sensitivity or just the
wrong connection string format.
I've successfully connected to a different linked db but it is a remote MS
SQL so I use the link.db.owner.table format for that.
Thanks in advance.
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by
me
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12
www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
