create table tableb as
    select . . .
    from tableA;