Hi,
I am trying to create Tables and corresponding audit tables in different Table spaces using a single DB User in ORACLE 10/11 G. I am using Hibernate 3.3/3.5 and Jboss Envers 1.2.2. I have seen some Hibernate issue tracker that says it will not be supported through Hibernate/envers annotations/mapping for generating the DDL to create tables in a particular Tablespace.

http://opensource.atlassian.com/projects/hibernate/browse/HBX-668

What I would like to know is whether there to a way to specify the Tablespace name through any annotation/configuration/Property so that the generated DDL through hbm2ddl component
generates the schema like:

I NEED SOME CONFIRMATION , whether it is supported or not as we are building a POC this information is needed. So, please respond

CREATE TABLE SOMEUSER.SOMETABLE
(
ID NUMBER(10, 0) NOT NULL,
TIMESTAMP NUMBER(19, 0) NOT NULL,
USER_NAME VARCHAR2(255 BYTE) NOT NULL
, PRIMARY KEY
(
ID
)
ENABLE
)
TABLESPACE "MYTABLESPACE" // this clause has to be created through hbm2ddl
LOGGING
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE
(
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
;