Create table new_tab as Select * from old_tab;

This won't create the indexes tho'