Missing right parenthesis

[karlectomy]

Hi all,

I'm trying to run this table creation script but I run into the ORA-00907 error: missing right parenthesis. Perhaps someone might know where I am going wrong?

CREATE TABLE RADLEX.radlinks (
  PID varchar(30) NOT NULL,
  CID varchar(30) NOT NULL,
  relation_type varchar(25) NOT NULL,
  preferred tinyint(1),
  PRIMARY KEY  (PID,CID,relation_type)
)DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
 

Best Wishes,

karl

[amitpatel66]

Hi all,

I'm trying to run this table creation script but I run into the ORA-00907 error: missing right parenthesis. Perhaps someone might know where I am going wrong?

CREATE TABLE RADLEX.radlinks (
  PID varchar(30) NOT NULL,
  CID varchar(30) NOT NULL,
  relation_type varchar(25) NOT NULL,
  preferred tinyint(1),
  PRIMARY KEY  (PID,CID,relation_type)
)DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
 

Best Wishes,

karl

Try this:

SQL> ed
Wrote file afiedt.buf
 
  1  CREATE TABLE APPS.radlinks (
  2    PID varchar(30) NOT NULL,
  3    CID varchar(30) NOT NULL,
  4    relation_type varchar(25) NOT NULL,
  5    preferred int,
  6    PRIMARY KEY  (PID,CID,relation_type)
  7* )
SQL> /
 
Table created.
 
 

I have changed tinyint to int and removed DEFAULT CHARSET and COLLATE options