Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Erwin - Does this thing work?
There is a way around that pesky FK problem. Unfortunately we are using
it... No FK's.
And they wonder why they have data problems...
-----Original Message-----
johanna.doran_at_sungard.com
Sent: Monday, May 06, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
> Hi Lisa,
>
> Yes. But its a little convoluted. It took me quite some time to do it.
Depends what you want included. IE. storage paramters etc.
>
> This is the product I use to generate all of our models and YES, it
drives me nuts. They had a bug in the last version that didn't allow the FK
constraints ddl to be generated properly! I am still having alot of issues
with it but it has the company's STAMP OF APPROVAL, so its what I need to
use <sigh>.
>
> Anyway, I use the OPTIONs under Forward Engineer and Created Several
Templates (forget what THEY call'em). First I generate scripts for the
tables with named PKs. Then the named FKs, then finally the indexes. THis
way I can review them in a reasonable way instead of just spewing them all
out there.
>
> Feel free to shoot me any specific questions.
>
> Hannah
>
> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of "Koivu, Lisa"
<lisa.koivu_at_efairfield.com>
> Sent: Monday, May 06, 2002 12:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OT: Erwin - Does this thing work?
>
> Hello all,
>
> I spent the weekend screwing around with Erwin. What a waste. I could
not
> believe how poorly it generated DDL. Has anyone gotten this product to
> generate DDL in a readable, logical manner?
>
> I am using Version 4.0, SP1
>
> Lisa Koivu
> Oracle Database Big Baby Oven
> Fairfield Resorts, Inc.
> 5259 Coconut Creek Parkway
> Ft. Lauderdale, FL, USA 33063
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Koivu, Lisa
> INET: lisa.koivu_at_efairfield.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: johanna.doran_at_sungard.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: ksmith2_at_myfirstlink.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon May 06 2002 - 21:28:22 CDT