Re: Converting CHAR to VARCHAR2

Zephyr wrote:
> Hi,
>
> I've inherited a database schema of Oracle 9i with some
> char columns that can't be used from a GUI interface.
>
> I need to convert these columns from char (5) to varchar2 (5).
> OK, i can drop the constraints create new tables with the rigth
> datatype, insert the tuples ... correct the old table and
erverything back.
>
> Is there a possible other solution the convert the datatypes in an
easy way.
>
> Thanks
> Patrick

1. Drop indexes.
2. alter table table_name modify (column_name varchar2(5));
3. Remove right padding from the values that were created by char. update table_name set column_name = rtrim(column_name);
4. Recreate indexes.

Regards
/Rauf Received on Mon Feb 07 2005 - 03:51:34 CST