Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Visio generate a Valid Oracle DDL Statement ?

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@standardandpoors.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US