Re: No automatic indexes

Brex wrote:
> Hi!
>
>
> Can someone please explain to me how not to generate indexes
> automatically when I create a table with PK in Oracle?
>
> Thank you in advance!
>
> Brex
>

Sorry, but you cannot. Oracle uses a unique index to help it enforce the PK constraint. You cannot have a PK constraint without an index.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown