Can Visio generate a Valid Oracle DDL Statement ?

From: xtanto <krislioe_at_gmail.com>
Date: 12 Oct 2004 04:29:55 -0700
Message-ID: <e1c9bd55.0410120329.3935f874@posting.google.com>

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 Received on Tue Oct 12 2004 - 06:29:55 CDT