db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Woonsan Ko <woon_...@yahoo.com>
Subject Setting tablespace during generating DDLs.
Date Fri, 14 Dec 2007 06:55:38 GMT
Hi All,

I'd like to set tablespace setting for oracle server during generating ddls with DdlUtils.
Is there any way to do this?

Here's my example output for this usecase:

CREATE TABLE EMP
(
    EMPNO NUMBER(10,0) NOT NULL,
    ENAME VARCHAR2(80) NOT NULL
    PRIMARY KEY (EMPNO) USING INDEX TABLESPACE &TS_TEST STORAGE(INITIAL 5M NEXT 5M)
)
TABLESPACE &TS_TEST
INITRANS   1
MAXTRANS   255
STORAGE (INITIAL 10M NEXT 10M);


Regards,

Woonsan


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ



Mime
View raw message