Re: Can Visio generate a Valid Oracle DDL Statement ?
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 14 Oct 2004 17:59:07 -0700
Message-ID: <1097802033.925575_at_yasure>
>>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.
Date: Thu, 14 Oct 2004 17:59:07 -0700
Message-ID: <1097802033.925575_at_yasure>
[Quoted] 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.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Oct 15 2004 - 02:59:07 CEST