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
