Re: easy question...i think

create table newtable1 as select ... from mytable; create table newtable2 as select ... from mytable; rename mytable to oldtable;
create view mytable as ... ;

--
Paul Baumgartel, Principal Consultant   
paul.baumgartel_at_worldnet.att.net
Adept Computer Associates, Inc.          (203) 735-3524