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
/
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
/