Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Non-primary key constraints in Oracle
A copy of this was sent to joelga_at_pebble.org (Joel Garry)
(if that email address didn't require changing)
On Fri, 26 Jun 1998 00:15:11 GMT, you wrote:
>On Thu, 25 Jun 1998 01:55:44 GMT, Thomas Kyte <tkyte_at_us.oracle.com> wrote:
>>
>>do you have a unique CONSTRAINT on the table or just a unique index. the index
>>is not good enough (in fact, unique indexes aren't even documented :)...
>
>I see references to CREATE UNIQUE INDEX syntax in both 7 (Administrators
>Guide p. 8-38) and 8 (SQL Ref)?
>
Ahh, I see that with 7.2 they started documenting them again. They were documented in 6.x and dropped from the docs in 7.0 and 7.1. I just never re-read the create index syntax since then..... sorry.
So, starting with the 7.2 doc set, CREATE <unique> INDEX is documented, in the 7.0 and 7.1 doc set, it is not....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jun 26 1998 - 07:54:15 CDT