Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ORA-00907: missing right parenthesis

Posted on 2008-11-07
2
Medium Priority
?
872 Views
Last Modified: 2013-12-19
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
0
Comment
Question by:gyans
  • 2
2 Comments
 
LVL 74

Expert Comment

by:sdstuber
ID: 22905665
Use NUMBER(38,0)  instead of bigint

instead of BIT  use NUMBER(1,0)
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 22905816
also in oracle, varchar2  is recommended varchar

and DATETIME should just be DATE
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month21 days, 3 hours left to enroll

810 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