Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: Can Visio generate a Valid Oracle DDL Statement ?

From: Daniel Morgan <>
Date: Fri, 15 Oct 2004 18:49:25 -0700
Message-ID: <1097891453.205783@yasure>

Galen Boyer wrote:

> On Thu, 14 Oct 2004, wrote:

>>Galen Boyer wrote:
>>>On Wed, 13 Oct 2004, 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...

 From why I've seen of it it is optimized for, amazingly, M$ $QL $ERVER. I barely knows Oracle exists. Want a decent storage clause? Want a GTT? Want an IOT? Want an external table? Want partitions and subpartions? Want object anything ... look elsewhere.

Daniel A. Morgan
University of Washington
(replace 'x' with 'u' to respond)
Received on Fri Oct 15 2004 - 20:49:25 CDT

Original text of this message