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.
No. And please change your nickname to "NEW2ORACLE". Thanks.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jan 16 2007 - 10:19:46 CST
