Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Insufficient Privileges when creating unique index
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
![]() |
![]() |