Try this
create table newtable as select set_of_columns from oldtable
Rich Ryan wrote
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