unable to use identity columns

[sameer kumar]

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

i am able to create the table if i remove identity attribute

Please help

regards
sameer

[Beksy Kurian]

Identity column is a sqlserver or access option. If you want to create an auto-incrementing column in oracle, you have to use sequence and triggers.

Beksy