Re: Weird ODBC Issue

I don't use primary keys on tables.
I'm using only unique index.

Primary keys are problem on slow HW.

JP

On Mon 18. February 2002 16:38, you wrote:
> What good is a table without a primary key? I know that some duhsigners
> sometimes create them, but the DBA should attempt to block shuch a duhsign.
>
> -----Original Message-----
> Sent: Monday, February 18, 2002 9:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Do they have primary keys? I seem to remeber that Access needed the Oracle
> table to have a primary key on it.
>
> -----Original Message-----
> Sent: Friday, February 15, 2002 4:43 PM
> To: Multiple recipients of list ORACLE-L
>
>
> No clue. User installed.
>
> -----Original Message-----
> Sent: Friday, February 15, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What ODBC Driver are you using? I've seen this with certain builds of
> Microsoft's driver, really quirky on W98.
>
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
>
>
>
> "Bellows,
>
> Bambi" To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> <BBellows_at_usg. cc:
>
> com> Subject: Weird ODBC Issue
>
> Sent by:
>
> root_at_fatcity.c
>
> om
>
>
>
>
>
> 02/15/2002
>
> 11:34 AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> I'm not exactly sure why, but I have a user who wants to see Oracle tables
> in Access. Whatever. So, the user can go into our pal SCOTT/TIGER no
> problem and look at tables from user_tables (not all_tables, which I find
> weird, but, what the hay). But, if the user tries to go into APPS/APPS, he
> can only see one table, and that one is owned by ADS.
>
> Anyone have similar problems? Any clue as to a resolution? Let me know...
> Yer pal,
> Bambi.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).