Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

not able to use identity attribute in oracle

 
sameer kumar
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

i dont have any primary key in the table. so i decided to use IDENTITY columns instead. i used the following query in oracle 9i:

create table kbtable (RELATEDTO VARCHAR2(100) NOT NULL,
GENERALSUBTYPE VARCHAR2(200) NOT NULL,
ISSUEOPENDATE DATE NOT NULL,
ISSUESTATUS VARCHAR2(7) NOT NULL,
ISSUE VARCHAR2(1000) NOT NULL,
UPDATEGIVENBY VARCHAR2(100),
ADDEDBY VARCHAR2(2) NOT NULL,
ADDEDONDATE DATE NOT NULL,
LASTMODIFIED DATE ,
LASTMODIFIEDBY VARCHAR2(2),
ISSUE_ID INT IDENTITY PRIMARY KEY )

but i am getting an error:

missing or invalid option

Please help

regards
sameer
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic