torque and tablespaces

[Evert-Jan van Tuijl]

hi

i'm using the latest torque with oracle and db2.

Wenn creating tables I'd like to specify the tablespace(s) in which I want
the data.
Up till now I've just adjusted the Velocity templates, but that isn't
flexible enough.

Does somebody have solutions / ideas for this problem? 



My own thoughts, but that need some enhancements to torque:

<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE database SYSTEM
"http://jakarta.apache.org/turbine/dtd/database.dtd";>
<database>
        <table name="TestTable" dataSpace="dataSpaceX"
indexSpace="indexSpaceY" lobSpace="lobSpaceZ">
                <column name="c1" required="true" type="INTEGER"/>
                <column name="c2" type="CLOB"/>
                <index name="TestIndex">
                        <index-column name="c1"/>
                </index>
        </table>
</database>

... that will generate in Oracle something like the following. DB2 is even
easier. 

CREATE TABLE TestTable (
c1 INTEGER,
c2 CLOB
)
LOB (c2) STORE AS (TABLESPACE lobSpaceZ DISABLE STORAGE IN ROW)
TABLESPACE dataSpaceX;

CREATE INDEX TestIndex ON TestTable (c1) TABLESPACE indexSpaceY;






--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>