Re: Des2K (Rel 2): DDL with tablespaces, etc.

"Ilya S. Itkin" <iitkin_at_houston.geoquest.slb.com> wrote:

>Designer/2000 (Rel 2)
>
>(1) I defined tablespaces and storage for some tables in Des2K.
>
> I want them to make it into my generated DDL files. How to?

You have to associate the TABLE IMPLEMENTATION for each TABLE/USER/SCHEMA/DATABASE combination with your TABLESPACE and STORAGE definition. You'll find this by drilling down in the Design Editor Navigator window. (I don't recall which tab it is).

>
>(2) How to access/update/insert/delete column comments in Des2K?

This should be a property of the column definition. Select a column in the navigator and be sure you have the property pallette displayed (not the dialogs).

>
>(3) On the server model diagram I set column customization to display
> Maximum Length. If the max length is defined it looks OK, but if it
> is not defined (e.g. for the NUMBER data type without length
>specified),
> the diagram shows <Maximum Length> literally after column names.
> Can I somehow get rid of that bearing-no-info <Maximum Length>?
>
> Diagram example:
> ...
> 789 | DUDE_ID - <Maximum Length>
> A | DUDE_NAME - 40
> ...
>
> What I would like to see:
> ...
> 789 | DUDE_ID
> A | DUDE_NAME - 40
> ...
>
>TIA for any comments/advise.
>
>Ilya

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com Received on Fri Jul 03 1998 - 05:11:07 CEST