Converting an existing table column from char to varchar2

From: fmhabash <fmhabash_at_gmail.com>
Date: Wed, 29 Feb 2012 14:08:33 -0500
Message-ID: <4F4E77B1.8020803_at_gmail.com>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 29 2012 - 13:08:33 CST