Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: invalid datatype error when creating primary key
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
+-----------------------------------------------------