Re: Creating Table as select...

hrishy wrote:

> Hi Daniel
>
> Can you please exaplin me why..that i should prefer unique constraints
> over unique indexes.
>
> regards
> Hrishy

Can't defer unique index ... can defer unique constraint Can't disable unique index ... can defer unique constraint Only option with a unique index is to drop it

Create a unique constraint and look at the entries in user_constraints and user_indexes ... try the same thing after building a unique index.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)