ORA-00907: missing right parenthesis

Posted on 2008-11-07
Last Modified: 2012-05-05
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

Open in new window

Question by:gyans
    1 Comment
    LVL 5

    Accepted Solution

    You cannot specify the BIGINT data type in a CREATE TABLE statement when you create a Oracle table. Use number instead.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (,  installed and started the daemon, and had a console window open. After an hour or two of playing at the command … is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now