create table SEGMENT CREATION IMMEDIATE

General Discussion
1

Due to a bug in Oracle 11g I need to create my tables with the following option: SEGMENT CREATION IMMEDIATE, besides using SQL tag is there any other way of doing this?

create table test_tab(
col1 number
) SEGMENT CREATION IMMEDIATE
;

The issue arises when creating a table, sequence and then trying to insert data using the sequence.

For more info on the issue check here: http://orawin.info/blog/2010/04/25/new-features-new-defaults-new-side-effects/

2

(catching up with posts after holiday)

You can use the tag to append the SEGMENT CREATION IMMEDIATE to the normally generated SQL from the createTable tag.  With 2.0, you can also create a class that extends CreateTableGenerator and automatically add it to all createTable changes without anything in the changelog.

Nathan