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 <[EMAIL PROTECTED]> > <BBellows@usg. cc: > > com> Subject: Weird ODBC Issue > > Sent by: > > [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).