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

Open in new window

LVL 1
gyansAsked:
Who is Participating?
 
SmartIntelConnect With a Mentor Commented:
You cannot specify the BIGINT data type in a CREATE TABLE statement when you create a Oracle table. Use number instead.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.