Hello,

Does anyone know if it is possible to configure hibernate to set table and index properties when generating the schema(hbm2ddl) in Hibernate 3 ?

For example, I would like hibernate to set the INITRANS,PCTFREE,PCTUSED parameters when creating the schema in oracle, It would also be nice to be able to tell hibernate to create index-organized-tables instead of the standard table type.

Is this possible or do I have to create a sql script with alter statements and run it after the schema generation.

Any replies or thoughts would be greatly appriciated.

Since any reply are welcome there are my 2c:

You seem to care about DB a lot, very well! Therefore I suggest you to manage DB creation script yourself, possibly with using highly specialized tools like ErWin or DeZign.

ErWin has an excellent feature: “compare model and actual DB”. It allows nice visualization of changes and also provides convenient environment to create schema update scripts. Nice thing to have in case of migration.

Hibernate is wonderful ORM tool, but DB maintenance should be closely controlled and left to specialized tools or people.

:-) I do care about the DB, and I have worked with Oracle(DBA/Designer and dataaccess layer) for approx 8 yrs and im well aware of ErWin and such tools.

The reason for my question is not that I want to let hibernate do my production schema for me(god NO!),I want hibernate to create our test and verification schemas with reasonable parameters.. this is required for performance tests and such, but I do not want to maintain manual/semimanual DB create scripts in this phase of the project.