Re: Can Visio generate a Valid Oracle DDL Statement ?
From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 14 Oct 2004 07:46:15 -0500
Message-ID: <uoej5a2rg.fsf_at_standardandpoors.com>
>> 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
Date: 14 Oct 2004 07:46:15 -0500
Message-ID: <uoej5a2rg.fsf_at_standardandpoors.com>
[Quoted] 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?
-- Galen BoyerReceived on Thu Oct 14 2004 - 14:46:15 CEST