Re: How to get to the Oracle system table names with ODBC in Access

You have to connect to the Oracle as a user with dba priveleges in order to view a system tables/views. In this case ODBC can see system tables/views at ALL_TABLES view also.

In order to work with an Oracle view as a bounded table you have to create the fake primary key upon this bounded table on Access side ( CREATE INDEX ON <bounded table>.<pk_column> WITH PRIMARY)

Vit.

On Wed, 31 Jan 2001 21:59:59 +0000, Andy Hardy <newsjan01_at_ahardy.demon.co.uk> wrote:

>In article <957a1a$5cq$1_at_ih292.ea.unisys.com>, NoSpam
><NoSpam_at_NoSpam.com> writes
>>I'm using ODBC with MsAccess to read an Oracle system table (something like
>>SYS.ALL_ALL_TABLES) in order to get to the DB data dictionary. The ODBC
>>connection works all right with other user tables but it just doesn't work
>>with system tables. What I'm trying to do is this:
>>
>>Set rst = dbs.OpenRecordset("SELECT * FROM SYS.ALL_ALL_TABLES",
>>dbOpenForwardOnly)
>>
>>Access ODBC mistakes it as SYS.MDB and reports the table missing. I realize
>>the "." is translated to "_" when Access links to an Oracle table. Then I
>>use SYS_ALL_ALL_TABLES but it still say "SYS_ALL_ALL_TABLES table not
>>found". Just how can I read a system table from Oracle?
>>
>>
>>TIA
>>
>>
>>
>
>Isn't sys.all_tables a view? Doesn't MSAccess/ODBC have a problem with
>working with anything that doesn't have a primary key e.g. views?
>
>Andy

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Sat Feb 03 2001 - 17:38:33 CET