First suggestion, download and apply the following patch:
ftp://exchange.rational.com/exchange/outgoing/dm_patch/ dm_patch.ZIP To install this patch, shut down Rose, then unzip this file to the datamodeler directory which by default is: C:\Program Files\Rational\Rose\datamodeler and answer yes to overwrite existing files. Restart Rose. This patch fixes some problems parsing a Oracle 8 DDL. If that does not correct the problem, please COPY and post the _exact_ error message from the Rose log along with the line triggering the error from the DDL (open up the DDL file in a text editor, and go to the line number identified in the Rose log). Patrick Kennedy Rational Support -----Original Message----- From: Williamson, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 3:39 AM To: '[EMAIL PROTECTED]' Subject: (ROSE) Reverse-engineering Oracle DDL Hi guys, I'm having problems reverse-engineering an Oracle 8i DDL script into Rose Professional Edition 2002.05.01. I created the DDL by using Oracle's "imp" command on a .dmp file, using the "indexfile" clause. When I read it into Rose, it complains about the word "constraint" in the DDL - I get messages like "error... encountered 'constraint' at column 32..." and it doesn't appear to import anything successfully. It's a fairly simple schema; 35 tables with primary and foreign keys, no indexes, no triggers or stored procedures. Can anyone help me import it successfully? TIA Nick Nick Williamson Software Development Engineer Harness Systems Division Mentor Graphics Corporation Edward Court, Altrincham Business Park Altrincham, Cheshire WA14 5GL UK http://www.mentor.com ************************************************************************ * 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: <BLANK> * Body: unsubscribe rose_forum ************************************************************************* ************************************************************************ * 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: <BLANK> * Body: unsubscribe rose_forum *************************************************************************
