On Thu, 14 Oct 2004, damorgan_at_x.washington.edu wrote:
> Galen Boyer wrote:
>
>> On Wed, 13 Oct 2004, damorgan_at_x.washington.edu wrote:
>>
>>>xtanto wrote:
>>>
>>>>Hi all, I am designing DB model for Oracle 9i using Visio for
>>>>enterprise architect , when I generate the script, I get this
>>>>script : create table ISTRI_P ( SI_PNSNIP CHAR(9) not null,
>>>>SI_POSISI CHAR(1) not null, SI_TGLNIK DATE null, constraint
>>>>ISTRI_P_PK primary key (SI_PNSNIP, SI_POSISI) ) ; This is a
>>>>valid code but not enough, I need to specify additional
>>>>clause, like which tablespace to use, Logging nor NO LOG,
>>>>Using INDEX or not etc.. I have to add manually this
>>>>additional clause : TABLESPACE APP01; When I create Index I
>>>>need to add this code : LOGGING TABLESPACE IDX01; When I
>>>>create Primary key I need to add this clause : USING INDEX
>>>>TABLESPACE IDX01; How can I make visio automatically generate
>>>>this additional clause for the DDL ? Thank you for your
>>>>help, xtanto
>>>
>>>No. Unless you are looking for badly written code pretty much
>>>guaranteeing a poorly performing unscalable end product.
>> I don't understand your response Daniel. Are you saying a
>> data modeling tool shouldn't be able to support the needs of
>> the OP?
>>
>
> Of course not. I am saying that a data modelling tool that
> can't properly write DDL is of extremely limited value.
I see. I don't know if Visio can do that or not. Have heard
very good things about it though. Hard to believe though...
--
Galen Boyer
Received on Fri Oct 15 2004 - 07:21:10 CDT
