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 -> Re: invalid datatype error when creating primary key

Re: invalid datatype error when creating primary key

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/04/14
Message-ID: <33528E25.1DB0@ebmud.com>#1/1

Check the compatibility of the database. Databases that were originally Oracle6 and were upgraded to Oracle7 often have compatibility set to V6. You get this error message using Oracle7 syntax against a database that is running with compatibility V6. To correct, use V6 syntax, or (in SQL*Plus) use SET COMPATIBILITY V7. Better yet, SET COMPATIBILITY NATIVE, which will then match the compatibility of the database.

+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect
| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com
 +-----------------------------------------------------

> >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
> >>
Received on Mon Apr 14 1997 - 00:00:00 CDT

Original text of this message

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