Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00001 when populating table
I am stepping through a 3rd party how-to book on Oracle8. The book calls for
creating an ORDER_DETAILS table in Oracle8 Navigator with a NO DEFAULT, NOT
NULL, NOT UNIQUE ORDER_ID primary key field. The book then calls for
populating the table with records, several of which have the same ORDER_ID
number.
The first time I try to enter a record with the same ORDER_ID number as a previously entered record, I get:
ORA-00001: unique contraint ... violated
What am I doing wrong? Thanks for any help.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 31 1998 - 08:33:29 CST