| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ERD generation tool
All bugs that I am experiencing are in 3.5.2. A lot of the problems
with ERwin are not CA's fault. And trust me, I have no respect for
CA.
-----Original Message-----
Chris
Sent: Thursday, May 02, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Yes, I always have that box checked. I still get an mixed order columns when I gen the DDL.
Yes, 4.0 sucks. One of the projects here actually purchased 4.0, but then had to fall back to 3.5.2, because of the bugs. Let's all thank CA for taking another fine product and destroying it.
-----Original Message-----
Sent: Thursday, May 02, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L
As I remember (since I'm no longer using ERWin since CA's takeover) there is a "Physical Order" box somewhere than needs to be clicked. If you do this, ERWin will use the actual physical order of the table, otherwise it will put them in another order (I think that it's primary key, foreign keys, and then alphabetical). The latest version of ERWin just isn't bug free enough for me to use as a primary tool --- so I'm using nothing. If I can't trust a tool then I can't use it.
"Grabowy,
Chris" To: Multiple recipients of list
ORACLE-L
<cgrabowy <ORACLE-L_at_fatcity.com>
@fcg.com> cc:
Sent by: root Subject: RE: ERD generation
tool
05/01/2002
06:56 PM
Please
respond to
ORACLE-L
No, no Paul is stating it as a bug. This has happend to me, where on
occasion ERwin decides to move columns around for no reason when it creates
the table in the database. I have looked at every single option and I
can't
find anything, so I am assuming it's a bug.
But if anyone knows otherwise...please do share...
-----Original Message-----
Sent: Wednesday, May 01, 2002 6:32 PM
To: Multiple recipients of list ORACLE-L
I have seen it create two columns with the exact same name in a table. It did this by putting double quotes around the column it was adding (that actually already existed.)
What's so bad about moving the pk fields to the top? Why would you put
them
in the middle of the table? I think having pk at the top is more readable,
and it assists with more optimal storage at a very low level.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
> -----Original Message-----
> From: Paul Li [SMTP:paul.li_at_sanchez.com]
> Sent: Wednesday, May 01, 2002 6:17 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ERD generation tool
>
> ERWin change the column sequences when using Reverse Engineering to
> generate
> diagram. It puts all of primary key columns on the top. But, actually
some
> primary key columns are in the middle of table. That is really bad. Does
> anybody see the same problem?
>
>
>
> -----Original Message-----
> Sent: Wednesday, May 01, 2002 5:01 PM
> To: Multiple recipients of list ORACLE-L
>
>
> ERWin's not much better. Has some better modeling capability as you
might
> guess, but has some VERY annoying quirks too. You also need to drill
down
> endlessly when doing a compare and I have seen it see two exact tables
> (even
> case being the same) and see them as different. The DO have a MATCH
> button
> that I would SUPPOSE allows you to re-align them, but I would not know
for
> sure as I get Dr. Watson's whenever I press it and the whole thing
> crashes!
>
> I had a nice BUG last week only. Generated scripts for the model, ran
> them
> on the db, then ran a compare from the model to the db. Darn thing came
> up
> with differences....
>
> Furthermore, I find that if you work from the Logical Model (like I do),
> the
> changes are not equally presented to the physical model.... (ie name
> change./datatype change) and its NOT consistent with this behavior
either!
>
> It has a report builder, but it doesn't report on datatypes entered on
the
> Logical side (even though the datatype on the physical MAY be different)
=
> therefore you can't run any consistency reports between the Logical and
> Physical models.
>
> I have been using ERWin both as a modeling tool and a change repository
> for
> the model. I like to run several reports against a model (I call them
> the
> Sanity Checks Reports).... you know, make sure that all columns named the
> same (ie DESCRIPTION) are of the same datatype, length, etc.....
>
> Anyhow, I can rant and rant.
>
> ERWin's BIGGEST Annoyance is my book is that there is no UNDO feature and
> it
> is rather easy to accidentally drop and drag either a relationship or
> field
> when re-aligning the model......
> ugh....
>
> I wish we could get together a group and benchmark some relatively
unknown
> but stable modeling tool who's maker will listen to the DBA community and
> put their name in the market (IE. give them market share) in exchange for
> giving our community a tool that would actually work for us and work
well!
>
> Rant over now.
>
> Please continue.......
>
>
>
> >
> > * It cannot handle obejcts (CLOBs, BLOBs, ...) that are not stored
> inline.
> > If you place CLOBs in a different tablesapce form the rest of the row,
> you
> > will have to manually manipulate the DDL.
> >
> > * It has no schema-schema comparision capabilities, only schema-model.
> >
> > * Examining the results of schema-model comparision is extremely
> awkward,
> > time consuming, and aggravating. One has to continually "drill down"
in
> a
> > miniscule window using the "Windows Explorer" type interface to see
> anything
> > meaningful.
> >
> > There are some other significant deficiencies also. I talked to them
> about
> > all these and more. What I got was the same answer that I got two
years
> ago
> > also. "We'll put it on the enhancement request list." or "We've been
> > intending to do that."
> > Personally, I think that packages have been around long enough that a
> > multi-thousand dollar per seat tool should be able to handle them by
> now!
> >
> > Unfortunately, I don't know of any great modeling tool right now.
> Designer
> > does everything, but definitely has some quirks. If you use another
> RDBS,
> > it probably won't handle it well. In addition, it wants to do things
> its
> > own way, not your way. Some also say it has the world's most obtuse
> > interface. Simply sit someone that is familiar with modeling, but
> > unfamiliar with Designer, down in front of the GUI and see how long it
> takes
> > them to generate a readable ER diagram! (To make this "fair", compared
> to
> > other tools, don't give them any documentation other than the online
> help,
> > but start it up and connect it to a database before you turn it over).
> It
> > could be days, perhaps weeks!
> >
> > Don Granaman
> > [OraSaurus]
> >
>
> --
> 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: 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: Grabowy, Chris INET: cgrabowy_at_fcg.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: Thomas Day INET: tday6_at_csc.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: Grabowy, Chris INET: cgrabowy_at_fcg.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 Thu May 02 2002 - 19:48:26 CDT
 |
 |