Link to home
Start Free TrialLog in
Avatar of gyans
gyans

asked on

ORA-00907: missing right parenthesis

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
Avatar of Sean Stuber
Sean Stuber

Use NUMBER(38,0)  instead of bigint

instead of BIT  use NUMBER(1,0)
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial