Re: Oracle Designer

Lesley, we have used Oracle Designer for about 4 years now and would recommend it with some caveats:
1 - when you re-generate physical models from logical models (i.e. after you add a relationship or entity), remove *all* the objects from the existing model beforehand - designer can do some strange things if there are things already in the physical model.
2 - dont try to run it in less than 128 MB of memory under NT, particularly if you have things like email notifys.
3 - it will be slow, you cant make it faster (and will break things if you try), so have some light reading handy.
4 - create the repository database as a stand-alone instance of Oracle and add about 15% to the space requirements listed in the installation guide. Expect the scripts the create the repository to fail and require Oracle's assistance. 5 - dont ever run the scripts that designer generates directly without checking them carefully. They will be wrong.
6 - designer, like other design tools, is not really needed for smaller applications. If you have less than 50 tables and related indices, just say "no".

Lesley Boughner wrote:

> Hello everyone, I know this isn't exactly database related but I wanted to
> get some unbiased opinions about Oracle Designer if anyone out there has
> used
> it.
>
> We have recently completed the database design (on paper) for an Oracle 8i
> Database. I was about to begin creating that database on the server. I was
> at and Oracle Forms course and they strongly recommended that we use
> Designer to build the project. We had planned on developing using Oracle
> Developer, which we have already purchased and used a little.
>
> If anyone has experience with it could you answer a few questions for me:
> -is it worth the time to learn that product?
> -is it difficult to learn?
> -what benefits will it give us?
> -are there any drawbacks we need to consider?
> -there are only two of us working on this project & we have both recently
> gone through rigorous Oracle 8i database training and Oracle Developer - so
> we're leery of learning another new product .
>
> Thanks for your help, any input is appreciated.
>
> L. Boughner
> Vimich Traffic Logistics
Received on Thu Aug 17 2000 - 21:13:51 CEST