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

Home -> Community -> Usenet -> c.d.o.server -> 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: Wed, 13 Oct 2004 18:50:27 -0700
Message-ID: <1097718713.780089@yasure>


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.

And please only post to a single group ... the one most relevant to your question. If you don't know which one read the charter and the FAQ. Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Oct 13 2004 - 20:50:27 CDT

Original text of this message

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