Designer 2.1.1 Never finishes reverse engineering

From: <dperez_at_juno_nospam.com>
Date: Sun, 24 Jan 1999 12:51:00 GMT
Message-ID: <36ab158f.33515452_at_news.cwix.com>

Well, just when I thought Oracle COULDN'T find a way to make Designer perform 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 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".....

Hit the button.......................  runs, runs, runs... Gets to 99%.  Says

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 got blown up with a "can't extend segment on rollback segment"... SO, I set the 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 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 is 66MB at the moment.......... TO GET 5 TABLES...

My God, no wonder my customers are using things like ERwin and Power Designer!!!

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