Tony,
I am able to sucessfully reverse engineer that DDL (Oracle 8.x) in Rose 2002.05.20. What version of Rose are you using?
Thank-you,
Paul Cooley
[EMAIL PROTECTED] wrote:
Hi,
I am trying to reverse engineer a ddl (Oracle 8) file into the Rose Data
Modeler and it keeps given me exception errors on the following syntax:
- DATE
- PRIMARY KEY
Is there a fix for this. Here is a sample of the ddl file:
CREATE TABLE OODT_LOAD_STATUS (
TABLE_NAME VARCHAR2(50) NOT NULL
CHECK ("TABLE_NAME" IS NOT NULL),
OPERATION VARCHAR2(100) NULL,
MESSAGE VARCHAR2(255) NULL,
TIME_STAMP DATE NULL
);
CREATE TABLE OODT_STATION_HISTORY (
HISTORY_DOC_ID NUMBER NOT NULL
CHECK ("HISTORY_DOC_ID" IS NOT NULL),
CUSTOMER_NUMBER VARCHAR2(9) NOT NULL
CHECK ("CUSTOMER_NUMBER" IS NOT NULL),
STATION_CODE VARCHAR2(8) NOT NULL
CHECK ("STATION_CODE" IS NOT NULL)
);
ALTER TABLE OODT_STATION_HISTORY
ADD ( PRIMARY KEY (HISTORY_DOC_ID, CUSTOMER_NUMBER,
STATION_CODE) ) ;
Thanks for your help
Ton! y Pham
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Post or Reply to: [EMAIL PROTECTED]
* Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
* http://www.rational.com/support/usergroups/rose/rose_forum.jsp
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
* To: [EMAIL PROTECTED]
* Subject:
* Body: unsubscribe rose_forum
*************************************************************************
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
