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 Boyer
Received on Thu Oct 14 2004 - 07:46:15 CDT
