I cant quite visualize how to do this. I need to use dbms_redefinition to
add a column to a table. In the process, I want to put a value in the
column based on a condition.eg, I want to add a column called changed_date,
and if the changed_indicator column is 1, I want to populate the value with
date_added, otherwise I want to put a high value in the column.
Once the redefinition process is complete, the column will be maintained by
our software, but I cant quite figure out how to do this on the fly without
missing the records modified while dbms_redefinition is running.
Has anyone done this? Am I missing something easy here?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'