Re: Indexes ? or Constraints ?

In article <sevy_michael.1.013319D7_at_tandem.com> sevy_michael_at_tandem.com (Michael Sevy) writes:
>From: sevy_michael_at_tandem.com (Michael Sevy)
>Subject: Re: Indexes ? or Constraints ?
>Date: Mon, 15 May 1995 21:39:14 GMT
 

>In article <1995May15.001318.26108_at_ml.csiro.au> betlehem_at_ml.csiro.au (Andrew Betlehem) writes:
>>From: betlehem_at_ml.csiro.au (Andrew Betlehem)
>>Subject: Re: Indexes ? or Constraints ?
>>Date: Mon, 15 May 1995 00:13:18 GMT
 

>>In article 3E5_at_netcom.com, stanb_at_netcom.com (Stan Brown) writes:
>>> I am in the process of planing a migration from V6 to V7. Our
>>>V7 creation scripts have both UNIQUE declerations & CREATE UNIQUE INDEX
>>>comands in them. This of course won't work in 7.0
>>>
>>Why won't CREATE UNIQUE INDEX work in V7. It may not be documented, but it definately
>>works. They just didn't document them.

>>Andrew

>>---
>>___________________________________________________________________________
>>Andrew.Betlehem_at_ml.csiro.au Database Analyst
>>CSIRO Division Of Fisheries Pelagic Fisheries Resources
>>Aus Tel: 002-325-332 Aus Fax: 002-325-000
 

> The "CREATE UNIQUE INDEX" command will work in v7; however, Oracle states in
>the Migration Guide:
 

> Because unique indexes might not be supported in future versions of
> ORACLE, you should begin using UNIQUE or PRIMARY KEY integrity
> constraints instead of unique indexes.
 

>-michael

You can specify tablespaces, storage clauses etc. on your primary key clause that will be used when the index is created. Check you SQL ref manual.

Lawrence.... Received on Tue May 16 1995 - 00:00:00 CEST