Can you explain that a bit? Why would a primary key be a problem and unique
would not. Essentially, primary key constraint is "NOT NULL" constraint +
a unique index. The difference between the two is that primary key is a
declared
property of the table and, as such. can be used for logical modelling.
Unique index,
on the other hand is only used for access to the tables and it usually
allows
the NULL values. If your hardware is fast enough for the unique index, it's
fast enough for the primary key.
-----Original Message-----
Sent: Monday, February 18, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: MGogala_at_oxhp.com
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).
Received on Mon Feb 18 2002 - 13:18:19 CST
