How to alter the precision (size) of an existing column on a table

General Discussion
1

OK  I did it using the modifyDataType refactoring as follows :-

 

 <modifyDataType
            columnName=“column_name”
            newDataType=“varchar2(128)”
            tableName=“table_name”/>

 

I have to say this wasnt very clear that you could do this from the available “Documentation”

 

Shaun.

2

Hi,

 

I’m looking to create a changeset to perform the following refactoring using liquibase :-

 

 ALTER TABLE tablename MODIFY (column_name VARCHAR2(128));

 

 

I tried using the modifyColumn refactoring , but this is now deprecated ?

 

I dont want to use dropColumn and then AddColumn as the column whose precision I need to change already contains data.

 

So whats the best way of doing this ?

 

Thanks in advance.

 

Shaun.