SELECT INTO using Oracle

If NEW_TABLE already exists then ...

insert into new_table select * from old_table
/
If you want to create NEW_TABLE based on the records in OLD_TABLE ...

create table new_table as select * from old_table
/