Re: Using Designer for space estimation

jreid_at_stirlingonline.com wrote:
> Hi;
>
> I'm working with Designer v 9.0.2 and trying to learn how to use it for
> size estimation.
>
> I have created a small 3 entity ERD. I've provided initial, max,
> average and % growth parameters for each entity. Each entity has a
> couple of attributes.
>
> I have also specified average length information for each attribute.
>
> I ran the Database Design Transformer successfully (I think).
> Suggestions for confirming this are welcome!

You should see tables. And indexes. Tables should be named the plural of your entity name.
>
> I am running the Repository Report "Database Table and Index Size
> Estimates" (ckdbsz). I get a total of 6 pages, several with the size
> estimation formulae, but then 2 pages w/the name of my container but no
> other contents.
>

Hm - iir, that only worked if you had size data filled in on table level.

> I can't find any good doc about this from Oracle (checking
> tahiti.oracle.com) or through Google searches. Any leads about good doc
> or better anybody who's successfully doing this who'd point out what
> I'm missing would be great.

Online documentation of Designer used to be great; the internet does not provide much hints, indeed.
The reporting bit has improved greatly, but is still error prone - you might just hit a bad report definition

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...