Re: Convert Mysql table schema to Oracle table

From: Angsql <angsql_at_gmail.com>
Date: 23 Mar 2006 12:28:36 -0800
Message-ID: <1143145716.176153.206060@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; Received on Thu Mar 23 2006 - 14:28:36 CST