When I do somthing like
select cdate into table newt from oldt;
and say, row cdate in table oldt had a default value of 'now', the new table
newt doesn't have the default value anymore. This makes sense since it is
copying just data, not meta-data into the new table. So, is there a way to
alter the cdate row in the new table to have a default? Could not find an
alter table command for this.
Thanks,
Rich