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_at_posting.google.com>
[Quoted] Hi all,
Date: 12 Oct 2004 04:29:55 -0700
Message-ID: <e1c9bd55.0410120329.3935f874_at_posting.google.com>
[Quoted] Hi all,
I am designing DB model for Oracle 9i using Visio for enterprise
architect ,
when I generate the script, I get this script :
[Quoted] create table ISTRI_P (
SI_PNSNIP CHAR(9) not null, [Quoted] 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 - 13:29:55 CEST