| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Convert Mysql table schema to Oracle table
"Angsql" <angsql_at_gmail.com> wrote in message
news:1143145716.176153.206060_at_t31g2000cwb.googlegroups.com...
: Hi Jon/Mark
:
: This is how I made the changes based on the feed back I got from you
: guys. I am getting error " ORA-00907: missing right parenthesis "
: error. Could you please help.
:
: CREATE TABLE builds (
: build_id number(10) NOT NULL
: PRIMARY KEY (build_id),
: build_product varchar2(50),
: build_branch varchar2(100),
: build_type varchar2(20),
: build_release varchar2(20),
: build_changenumber number(10),
: build_date date,
: build_status varchar2(20)
: CONSTRAINT CK_builds_build_status CHECK (build_status IN
: ('succeeded','failed')) default 'succeeded',
: build_saved bit
: CONSTRAINT CK_builds_build_saved CHECK (build_saved IN ('y','n')),
: build_source varchar2(20)
: CONSTRAINT CK_builds_build_source CHECK (build_source IN
: ('vmware','community')) default 'vmware'
: )
: TABLESPACE USERS;
:
if you're executing this in SQL*Plus, it should also be showing you where the error is:
PRIMARY KEY (build_id),
*
in a fixed-width font the '*' lines up with (build_id)
you're using a table level constraint syntax for a column-level constraint
++ mcs Received on Thu Mar 23 2006 - 15:25:59 CST
 |
 |