First suggestion, if you are not using the object-relational features of Oracle (custom types, nested tables, object views, etc.) and instead are just using the standard relational features... try using the Data Modeler addin. The Data Modeler addin supports much more than the o8 addin does (procedures, triggers, tablespace, converting to object model, etc.) and is generally easier to use. Also the o8 addin is not being updated anymore (dead code). Data Modeler is contining to be updated.
OK, having said that, if you still want to use the o8 addin, You can create a new FK, but not edit an existing FK. Defect. Existing FK do not show up in drop down listbox in Edit Foreign Key Wizard. Workaround. Delete the existing FK, and add it back. To add a FK: 1. On your class diagram, select the relational table where you are adding/editing a foreign key. 2. Select Tools - Oracle8 - Foreign Key Wizard. 3. Type in a FK name 4. Highlight a table name. 5. Highlight the name of the col that is the PK NOTE table must have an existing Primary Key defined. 6. Press "Add Foreign Key" button you now should have a FK relation. Also note, you cannot mix the Data Modeler table and Oracle 8 tables. To add a FK using the Oracle 8 addin, you need to have created your table with the Oracle 8 data type creation wizard. Patrick Kennedy Rational Support -----Original Message----- From: Jean-Noel WALLEZ To: [EMAIL PROTECTED] Sent: 1/30/2002 2:37 AM Subject: (ROSE) Oracle 8 foreign key generation Hello, I'm new to rational rose 2001. I managed to create a class diagram and generate a schema script for oracle 8. My script include primary keys but I can't manage to add foreign key. Can anybody list me the steps required to translate an association to a foreign key. I try "Tools=>Oracle8=>Edit Foreign Keys" but got no results. thanks jean-noel ************************************************************************ * 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 *************************************************************************
