Issue BLOB Handle in Liquibase for Oracle with "DISABLE STORAGE IN ROW"

General Discussion
1

BLOB Data : Liquibase with Oracle

Issue :

How to create a table contains a column as LOB( BLOB/CLOB) with “DISABLE STORAGE IN ROW”

Description :

We are trying to create a table contains the BLOB data in Liquibase for Oracle DB

Now challenge is that we need this particular column ( BLOB) should not contain the date in row, instead it should be linked to a table space.

Means : We want to set the “DISABLE STORAGE IN ROW” for the BLOB Content

Now we are able to achieve the same if we run the SQL as follows for Oracle DB

CREATE TABLE DEVMDR1.VCH_ACTIVITY_DEFN

(

...</div>

CREATE_TS  TIMESTAMP,</div>

CREATED_BY VARCHAR2(50),</div>

DEFN_XML BLOB,</div>

MODIFIED_BY    VARCHAR2(50),</div>

MODIFY_TS      TIMESTAMP,</div>

...</div>

PRIMARY KEY (“ACTIVITY_DEFN_KEY”)

) LOB (“DEFN_XML”) STORE AS (

TABLESPACE “USERS” DISABLE STORAGE IN ROW CHUNK 8192

CACHE NOCOMPRESS ) ;

But we are unable to achieve the same using LIQUIBASE.

Can someone give views on the same as need to implement the same as the earliest.