Converting an existing table column from char to varchar2
- From: fmhabash <fmhabash@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Feb 2012 14:08:33 -0500
I have a need to do this conversion in a large table (10M) rows on a
10.2.0.4.0 database. My research let me to the following facts ...
Option 1) Using 'alter table .."
----------------------------------------
- Set BLANK_TRIMMING = TRUE
- disable triggers, constraints, drop indexes (?)
- varchar2 size must be >= current char size
- update varchar2 column set rtrim
Option 2) Rebuild table
If you have done this in the past, how was your procedure different and
what issue have encountered if any.
Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
