Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02253: constraint specification not allowed here

664341Oct 13 2008 — edited Oct 13 2008
I'm trying to create a table clients with primairy key, but I'm getting the error "ORA-02253: constraint specification not allowed here"

if anyone call what to do

CREATE TABLE CLIENTS
(
NUMERO NUMBER(6) CONSTRAINT PK_CLIENTS PRIMAIRY KEY,
NOM VARCHAR(63), NOT NULL,
PRENOM VARCHAR(63),
NAISSANCE DATE

);

Edited by: user10397656 on Oct 13, 2008 1:40 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2008
Added on Oct 13 2008
1 comment
4,004 views