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

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 <damorgan_at_x.washington.edu>
Date: Fri, 15 Oct 2004 18:49:25 -0700
Message-ID: <1097891453.205783@yasure>


Galen Boyer wrote:

> On Thu, 14 Oct 2004, damorgan_at_x.washington.edu wrote:
> 

>>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.
> 
> 
> 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
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 15 2004 - 20:49:25 CDT

Original text of this message

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