Re: invalid datatype error when creating primary key

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/07
Message-ID: <3347CD94.49B_at_hk.super.net>#1/1


Steve Miller wrote:
>
> 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:
> ORA-00902: invalid datatype
>
> 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.

Could it be because of the Unix Emulator which put some special character
in the name without being seen by you ? Try do it in one line with simple name. Received on Mon Apr 07 1997 - 00:00:00 CEST

Original text of this message