A new topic, 'Oracle 10g CLOB column modification', has been made on a board
you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=38.new#new
The text of the topic is shown below:
This isn't a huge deal, but I'm wondering if this will be changed in the future.
Currently if you run a change like:
Code:
<modifyColumn tableName="table">
<column name="cssClasses" type="text"></column>
</modifyColumn>
on a VARCHAR2 column in oracle the generated sql will be something like
Code:
SQL ALTER TABLE table MODIFY (cssClasses CLOB)
which will return with a ORA-22858: invalid alteration of datatype.
To get around it I've just created a seperate changeset for the oracle database
that creates a new column and copies the data over:
Code:
<addColumn tableName="table">
<column name="tempCssClasses" type="text"></column>
</addColumn>
<sql>update table set tempCssClasses = cssClasses</sql>
<dropColumn tableName="table" columnName="cssClasses"/>
<renameColumn tableName="table" oldColumnName="tempCssClasses"
newColumnName="cssClasses"/>
I realize I could just create a custom change to handle this, but I'm wondering
if this is a common enough problem that Liquibase might be changed in the
future to handle this automatically?
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
