Re: unique contraint without index

oracle dba wrote:
> Taral wrote:
> > Yes, you can create unique constraint on this two column and will not
> > create unique index
> >
> > ALTER TABLE table_name
> > add CONSTRAINT constraint_name UNIQUE (column1, column2, ... column_n);
> >
> >
> > On Jan 16, 12:07 pm, "oracle dba" <aoracle..._at_gmail.com> wrote:
> > > hi all,
> > > In my database I don't want any index on three columns (a,b and c) I
> > > need unique contraint on three columns, so that value will not repeat.
> > > Is it possible.
> > > And if no, then unique key is better or primary key for space usage
> > > prospective. Or if YES then pls tell me how.
>
> Is this possible for primary key without index.

How did you ever get your "oracle dba" name for this group?

Check out http://asktom.oracle.com or do some searching within cdos ... probably this question has been answered at least 100 times in the last couple of years. Received on Tue Jan 16 2007 - 08:04:43 CST