Designer 2.1.1 Never finishes reverse engineering

From: <dperez_at_juno_nospam.com>
Date: Sun, 24 Jan 1999 13:07:02 GMT
Message-ID: <36ab1a50.34732843_at_news.cwix.com>

[Quoted] Well, just when I thought Oracle COULDN'T find a way to make Designer perform [Quoted] worse than 1.3.2....... they managed.....

Designer 2.1.1 installation using PO 8.0.4 and ORACLE'S SEEDED DATABASE....

Reverse engineer a trivial set of tables into Designer - we're only talking 80 [Quoted] tables here and possibly 20 or so foreign keys...... Essentially mickey mouse.....

Runs. Read the database. Gets the stuff... Puts up the banner to "Save".....

[Quoted] Hit the button.......................  runs, runs, runs... Gets to 99%.  Says

[Quoted] its "Committing" NEVER FINISHES........ I let it run OVERNIGHT. Never finished.............

First time I did this USING ORACLES sizes of rollback tablespace and segments, I [Quoted] got blown up with a "can't extend segment on rollback segment"... SO, I set the [Quoted] rollback tablespace and segments to UNLIMITED..........

A single attempt caused the rollback tablespace to expande from whatever it originally was (around 2 MB as I recall) to 33MB....... That's the one that [Quoted] spent ALL NIGHT "Committing"..............

Now I'm trying to pull these in 5 or 6 tables at a time - which is pure, unadulterated, *&$_at_#@ but sort-of works............

I noticed that the SECOND rollback segment is now 32MB so my rollback tablespace [Quoted] is 66MB at the moment.......... TO GET 5 TABLES...

Oh, and once it gets to the "Commit" ABSOLUTELY PEGS the CPU for as long as it [Quoted] decides to commit... No disk activity. I've got the monitor running... NOTHING to the disk, just CPU. And for 10 tables, its been sitting here for [Quoted] over an hour - COMMITTING!!!!!!!!

My God, no wonder my customers are using things like ERwin and Power Designer [Quoted] and throwing this thing out!!!

So, how do I get this tablespace back down to a reasonable size? And how do I [Quoted] get this POS to reverse engineer in less than 8 hours for a few dozen tables? Received on Sun Jan 24 1999 - 14:07:02 CET