Why do you just drop that empty table ( call table_b), then do

create table_b as select * from table_a. It will create a table_b with the same name you drop and the data that contains in table_a.