ORA-00907: missing right parenthesis

I am creating a simple table in oracle 10g database ,getting the error.
Can some help please .
SQL>  create table CREDENTIALS
  2  (
  3          id bigint auto_increment NOT NULL,
  4          created_at datetime,
  5          auth_token varchar(255) not null unique,
  6          alias_user varchar(255) not null,
  7          alias_first_name varchar(255) not null,
  8          alias_last_name varchar(255) not null,
  9          alias_email varchar(255) not null,
 10          enabled bit not null,
 11          eod_user varchar(255) not null,
 12          eod_organization varchar(255) not null,
 13          eod_password varchar(255) not null,
 14          expires_at datetime not null,
 15          transaction_id bigint not null,
 16          primary key (id)
 17      );
        id bigint auto_increment NOT NULL,
                  *
ERROR at line 3:
ORA-00907: missing right parenthesis

na

Select allOpen in new window