As Jeff suggested you can use the CREATE TABLE AS SELECT, just remember also, you'll need to recreate your indexes and issue grants again to the newly table.
Sometime what I do is
a). CREATE TABLE new_table_temp AS ...
b). Take note of the grants adn indexes.
c). Drop the OLD table
d). CREATE TABLE old_name AS SELECT * FROM new_table_temp
e). Create indexes etc and grants
f). Drop table new_table_temp;
Cheers,




Reply With Quote