Link Table Wizard doesn't show all tables

[Cindy French]

I'm having an issue that I have fixed in the past, but I
don't remember how I fixed it. I am linking to an Oracle
Database with about a 1000 tables. I can only see about
the first 200-250 in the linked wizard. What do I need to
do to be able to see all of the tables? I can't find a
KB to tell me either.

Thanks in advance!!

Cindy

 

[Lynn Trapp]

Cindy,
It is possible that the user you are logging on as has Select privileges on
more than the 1000 tables you mention. Here, our programmers have Select
privileges on all tables, which includes all the dba tables. Therefore we,
very quickly, reach the maximum allowable by the ODBC drivers. The way we
fixed it is to create a dummy user that only has Select privileges on the
tables needed and create the linked tables using that user.

 

[Joe Fallon]

Agreed.
You are "overwhelming" the wizard with too many tables.
A special account that only has the ones you need will make this work just
fine!