Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insufficient Privileges when creating unique index

Insufficient Privileges when creating unique index

From: <kpkeller_at_linuxmail.org>
Date: 6 Dec 2004 08:16:05 -0800
Message-ID: <1102349764.973217.49440@z14g2000cwz.googlegroups.com>


Here is the SQL I'm using:

create table uniquetb(primary key(prikey), prikey integer, idcol integer, desccol varchar(20));
commit;
CREATE unique INDEX uppercase_idx ON uniquetb (idcol, UPPER(desccol)); commit;

Would someone please tell me why I receive an 'Insufficient Privileges' error when the 'create unique index' line executes?

I really need to create a composite Uniqueness constraint that encompasses two columns.

Thanks. Received on Mon Dec 06 2004 - 10:16:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US