MySQL Forums
Forum List  »  MySQL Workbench

Running Oracle's Scott/Tiger script
Posted by: Chris Theodore
Date: August 13, 2015 03:08PM

I am trying to run this script on my new installation of MySQL Workbench (6.3) - It errors out! I can create tables through the diagram, but Reveng of this Oracle script has not worked.

I have done this many times in the past with older versions with no problems, any suggestions?

CREATE TABLE VEHICLES
(
VECHL_TYP_CODE VARCHAR2(6) NOT NULL,
ODMTR NUMBER(8),
WORKING_RADIO VARCHAR2(1),
TANK_CPTCY NUMBER(3),
VECHILE_ID NUMBER(6) NOT NULL,
REG_STATE VARCHAR2(2) NOT NULL,
REG_NUM VARCHAR2(12) NOT NULL,
LST_MAINT_DT DATE NOT NULL,
REG_EXP_DT DATE NOT NULL,
VECHL_TYPE VARCHAR2(10) NOT NULL,
OFCS_ID NUMBER(3) NOT NULL
);

Options: ReplyQuote


Subject
Views
Written By
Posted
Running Oracle's Scott/Tiger script
2148
August 13, 2015 03:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.