
July 31st, 2012, 12:57 PM
|
|
Contributing User
|
|
Join Date: Jan 2006
Location: Carlsbad, CA
|
|
|
Suggestions for questions:
Q1. There is the obvious "backup first" could be a proper backup or simply create
a temporary table with all the old data. Make sure you take care of the
storage specs for the altered column.
Q2. Depending upon what tools you use, I think many support you selecting items
(i.e. views) and doing a "Compile all with dependencies". Only caveat (and I am not
sure if it was Oracle). I have had situations where Instead of triggers
just get wiped away.
Q3. See Q2. regarding "instead of" triggers.
|