Hi there
I am trying to use hbm2ddl (jpaconfiguration) to create my Oracle Schema directly. The tables are supposed to all be in one Oracle tablespace and all of the index in another. The only advice I have managed to find so far has been http://stackoverflow.com/questions/1274408/hibernate-oracle-tablespace-a nnotation , which recommends writing our own version of hbm2ddl ! We have tried extending the Dialect class and trying to generate the correct SQL that way, but the following part of the SQL generated does not seem to acquire the TABLESPACE. create table hibernate_sequences ( sequence_name varchar2(255 char), sequence_next_hi_value number(10,0) ) ; The basic question is how do I best assign ( a fixed ) tablespace to all tables and a different ( fixed ) tablespace to all teh indexes and sequence tables ? Thanks in advance Madjid Ghazi BJSS Ltd. 1st Floor, Coronet House Queen Street Leeds LS1 2TW United Kingdom T: +44 (0) 113 297 9797 F: +44 (0) 113 297 9798 E: [email protected] <mailto:[email protected]> W: http://www.bjss.com <http://www.bjss.com>
