Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> invalid datatype error when creating primary key
I'm trying to create some named primary keys on some tables in a 7.3.2.2 database and I'm getting the following error:
comex> alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01
2 primary key (user_cd, emp_cd);
alter table service.gp_cd2emp add constraint pk_gp_cd2emp1_c01
*ERROR at line 1:
I've tried adding quotes, parentheses, etc. and it just DOESN'T want to work. I can add an unnamed constraint just fine:
comex> alter table service.gp_cd2emp add primary key (user_cd, emp_cd);
Table altered.
Anyone seen this before - Oracle support is working on the problem, but I really need to push this project forward.
Any input appreciated!!
Steve Received on Wed Apr 02 1997 - 00:00:00 CST