RE: Erwin - Does this thing work?

That's one I haven't heard about!

> -----Original Message-----
> From: root_at_fatcity.com_at_SUNGARD On Behalf Of "Ji, Richard" <Richard.Ji_at_MobileSpring.com>
> Sent: Tuesday, May 07, 2002 11:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Erwin - Does this thing work?
>
> In our case, we had to add the following:
>
> In Windows settings, control panel, system, advanced, environment
> variables, add:
>
> Variable = NLS_LANG
> Value = American_America.UTF8
>
> Rich
>
> -----Original Message-----
> Sent: Monday, May 06, 2002 10:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ji, Richard
> INET: Richard.Ji_at_MobileSpring.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).