Re: converting data types

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 12 Jan 2006 12:47:12 -0800
Message-ID: <1137098832.106389.148700@g44g2000cwa.googlegroups.com>

1- Also check for Triggers (to disable/enable) 2- Also check for existance of Foreign key from other tables (to disable/enable)
3- Other dependant objects like materialized view (logs?) Export could also be used instead of CTAS.

The nice thing about doing a truncate, as opposed to;
- drop - is that you don't loose table privileges (grants)

update set...=null - you don't generate redo/undo

HTH Received on Thu Jan 12 2006 - 14:47:12 CST