Re: Preferred method in creating primary key

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 14 Aug 2003 06:14:48 +1000
Message-ID: <pan.2003.08.13.20.14.48.340569@yahoo.com.au>

On Wed, 13 Aug 2003 09:58:38 -0700, Daniel Morgan wrote:

> Noons wrote:
> 

>> Not all the options for CREATE INDEX
>> are in the Primay key clause. Not in 8i
>> anyway.
>>
>> --
>> Cheers
>> Nuno Souto
>> wizofoz2k_at_yahoo.com.au.nospam

>
> For example? I can't think of one.

Try creating a primary key on columsn A and B, and ask it to create an index that uses columns A, B and C.

Incidentally, fixed in 9i, because a complete create index statement is permitted *within* the create table statement... so Oracle must have seen that something was missing!

Regards
HJR Received on Wed Aug 13 2003 - 15:14:48 CDT